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:
Help! WebCat2 bug (Ben's input) (1997)
Adding multiple items to cart with one click? (2000)
UPS Shipping (1999)
2.1b3 --> way slow (1997)
insecuretextvars preference doesn't work (2000)
Methods of protecting "invoice page" (2003)
date formatting for CC card expiration date check (1998)
emailer (1997)
page chokes on hideif when false and ignored (1998)
RE: AccountAuthorizer doesn't seem to work (1997)
WebCatalog 2.0.1 NT beta 1 released (1997)
Credit card processing - UK (1997)
email program problem (1998)
Integration? (1999)
database search help (2003)
WebCat vs MS SiteServer? (1999)
[redirect] w/o showing args? (1999)
Limiting user access to .tmpl files (1997)
[click][/click] (1999)
WebCatalog2 Feature Feedback (1996)