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:
Removing [showif] makes a big difference in speed (1997)
authorizenet/webmerchant (2000)
[shownext] and descending order (1997)
CC verification (2001)
Windows 2000 Server & Webcatalog 3.x (2000)
WebCatalog/WebMerchant 2.1 (1998)
RE: How much ram??? (1997)
WebCommerce Security Alert! (1996)
Max Record length (1997)
[ListFiles] from a remote host (2003)
RE: Writefile outside WebSTAR hierarchy? (1997)
Time to opensource? was [SMSI] WebDNA is too good to (2006)
Fun with dates (1997)
RE: PDF (1999)
No Data Results (1997)
WebDNA 5.0 Questions (2003)
typhoon ? (2003)
Cart date/time (2006)
FW: WebCat Contest (1998)
send mail problem? (1997)