GKAt 03:27 AM 8/20/2004, you wrote:>I am writing data from a shoppingcart into a database. In my deployed>site it works fine in my dev site it is dropping the [texta] field and>only the texta field. [textb] etc all work fine. Here is the code>snippet it is exactly duplicate on both sites.>>[lineitems]>[append>db=databases/ >orderitems.db]oid=[neworderid]&oidi=[neworderid]_[lineindex]&oin=[linein >dex]&title=[textA]&quantity=[quantity]&sku=[sku]&price=[price]&taxable=[ >taxable]&canEmail=[canEmail]&unitshipCost=[unitshipCost]&textA=[textA]&t >extB=[textB]&textC=[textC]&textD=[textD]&textE=[textE]&orddate=[math]{[d >ate]}[/math]&ordtime=[math]{[time]}[/ >math]&ordatetime=[math]({[date]}*86400)+{[time]}[/math][/append]>[/lineitems]>>I look at the shopping cart just prior to posting this and I textA is>populated, weird thing is it only happens when there is a quote in the>texta field ie texta="Property Of" T-Shirt. I look at it in the>completed orders folder and its empty>>If I take the "'s out then it works fine. I tested this several times.>This is on a windows box running IIS and version 4.5. I tried grepping>out the "'s but no luck the shopping cart ignores any of my attempts to>change the texta field from what is in the database.-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list DOWNLOAD WEBDNA NOW! The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Gots to [url] dem values Bob![lineitems][append db=databases/ orderitems.db][!][/!]oid=[url][neworderid][/Url][!][/!]&oidi=[url][neworderid]_[lineindex][/Url][!][/!]&oin=[url][lineindex][/Url][!][/!]&title=[url][textA][/Url][!][/!]&quantity=[url][quantity][/Url][!][/!]&sku=[url][sku][/Url][!][/!]&price=[url][price][/Url][!][/!]&taxable=[url][taxable][/Url][!][/!]&canEmail=[url][canEmail][/Url][!][/!]&unitshipCost=[url][unitshipCost][/Url][!][/!]&textA=[url][textA][/Url][!][/!]&textB=[url][textB][/Url][!][/!]&textC=[url][textC][/Url][!][/!]&textD=[url][textD][/Url][!][/!]&textE=[url][textE][/Url][!][/!]&orddate=[math]{[date]}[/math][!][/!]&ordtime=[math]{[time]}[/math][!][/!]&ordatetime=[math]({[date]}*86400)+{[time]}[/math][/append][/lineitems]GKAt 03:27 AM 8/20/2004, you wrote:>I am writing data from a shoppingcart into a database. In my deployed>site it works fine in my dev site it is dropping the [texta] field and>only the texta field. [textb] etc all work fine. Here is the code>snippet it is exactly duplicate on both sites.>>[lineitems]>[append>db=databases/ >orderitems.db]oid=[neworderid]&oidi=[neworderid]_[lineindex]&oin=[linein >dex]&title=[textA]&quantity=[quantity]&sku=[sku]&price=[price]&taxable=[ >taxable]&canEmail=[canEmail]&unitshipCost=[unitshipCost]&textA=[textA]&t >extB=[textB]&textC=[textC]&textD=[textD]&textE=[textE]&orddate=[math]{[d >ate]}[/math]&ordtime=[math]{[time]}[/ >math]&ordatetime=[math]({[date]}*86400)+{[time]}[/math][/append]>[/lineitems]>>I look at the shopping cart just prior to posting this and I textA is>populated, weird thing is it only happens when there is a quote in the>texta field ie texta="Property Of" T-Shirt. I look at it in the>completed orders folder and its empty>>If I take the "'s out then it works fine. I tested this several times.>This is on a windows box running IIS and version 4.5. I tried grepping>out the "'s but no luck the shopping cart ignores any of my attempts to>change the texta field from what is in the database.-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list
Top Articles:
Talk List
Related Readings:
Document Contains No Data! (1997)
06/06/2000 bug warning ... (2000)
2.0Beta Command Ref (can't find this instruction) (1997)
RE: Credit card processing - UK (1997)
Nested vs conditional (1997)
Calculating Shipping (1997)
Weird Math and SV (1997)
Orders coming up blank (2004)
Problems with cybercash (2000)
HomePage Caution (1997)
WebDNA and WebSTAR Error pages II (2004)
Attention all list readers (1997)
Press Release hit the NewsWire!!! (1997)
Help! WebCat2 bug (1997)
can WC render sites out? (1997)
SPAM (OT) (2004)
Clear command and ShoppingCart.tmpl (1997)
Need help with emailer- 2 issues (1997)
WebCat2 Append problem (B14Macacgi) (1997)
bannerads example idiot (1997)