Re: How can I record purchases to a database?

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 17787
interpreted = N
texte = >Try this: > >[math]thiscart=[cart][/math]then laterCartNum=[math]thiscart[/math] Good luck!Sandy>Hi all, > >I submitted the following WebDNA and results: > >>[lineitems] >>[append db=NMI_Purchases.db] >>CartNum=[cart]&Qty=[quantity]&SKU=[SKU]&ProdName=[ProdName]&Price=[price] >>&Extension=[format .2f][quantityPrice][/format] >>[/append] >>[/lineItems] >> >>This returns close to what I want in the database - as follows: >> >>CartNum Qty SKU ProdName Price Extension >> 3 BN-1218 Red Nylon 13.00 39.00 >> 4 BN-1218P Red Nylon w/pocket 14.00 56.00 >> >>As you can see, I am getting everything but the [cart] number. I'm >>assuming that this is because the cart number is not part of the line >>items in the cart. (Makes sense.) >> >>Now my question is - How do I get the cart number to be included in the >>record that is written to the database? >> > >Ken Grome suggested I try this: > > >> >>Try this: >> >>[math]thiscart=[cart][/math] >> >>[lineitems] >>[append db=NMI_Purchases.db] >>CartNum=[math][thiscart][/math]&Qty=[quantity]&SKU=[SKU] >>&ProdName=[ProdName]&Price=[price] >>&Extension=[format .2f][quantityPrice][/format] >>[/append] >>[/lineItems] > >Ken, I got the same results. No cart number. Any other suggestions. I >fooled with all kinds of stuff tonight including trying a [SetLineItem] >context, all to no avail. It's so close to what I want. Hope some one can >shed some light on it. > >Jerry Nielsen - comm$TRUCT Associates > > >Jerry N. Nielsen Voice: (626)351-0201 >comm$TRUCT Associates Fax: (626)351-0033 >Managing Consultant Cellular: (818)257-2937 >3835 Landfair Road >Pasadena, CA 91107 > >We con$TRUCT commerce sites that work the way YOU want them to! > >Thought for the day: The longest distance between to points is a shortcut. >^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > > > > Associated Messages, from the most recent to the oldest:

    
  1. Re: How can I record purchases to a database? (Jerry Nielsen 1998)
  2. Re: How can I record purchases to a database? (PCS Technical Support 1998)
  3. Re: How can I record purchases to a database? (Jerry Nielsen 1998)
  4. Re: How can I record purchases to a database? (PCS Technical Support 1998)
  5. Re: How can I record purchases to a database? (Jerry Nielsen 1998)
  6. Re: How can I record purchases to a database? (Chris Gursche 1998)
  7. Re: How can I record purchases to a database? (Sandra L. Pitner 1998)
  8. Re: How can I record purchases to a database? (Jerry Nielsen 1998)
  9. re: How can I record purchases to a database? (Kenneth Grome 1998)
  10. re: How can I record purchases to a database? (Jerry Nielsen 1998)
  11. How can I record purchases to a database? (Jerry Nielsen 1998)
>Try this: > >[math]thiscart=[cart][/math]then laterCartNum=[math]thiscart[/math] Good luck!Sandy>Hi all, > >I submitted the following WebDNA and results: > >>[lineitems] >>[append db=NMI_Purchases.db] >>CartNum=[cart]&Qty=[quantity]&SKU=[SKU]&ProdName=[ProdName]&Price=[price] >>&Extension=[format .2f][quantityPrice][/format] >>[/append] >>[/lineItems] >> >>This returns close to what I want in the database - as follows: >> >>CartNum Qty SKU ProdName Price Extension >> 3 BN-1218 Red Nylon 13.00 39.00 >> 4 BN-1218P Red Nylon w/pocket 14.00 56.00 >> >>As you can see, I am getting everything but the [cart] number. I'm >>assuming that this is because the cart number is not part of the line >>items in the cart. (Makes sense.) >> >>Now my question is - How do I get the cart number to be included in the >>record that is written to the database? >> > >Ken Grome suggested I try this: > > >> >>Try this: >> >>[math]thiscart=[cart][/math] >> >>[lineitems] >>[append db=NMI_Purchases.db] >>CartNum=[math][thiscart][/math]&Qty=[quantity]&SKU=[SKU] >>&ProdName=[ProdName]&Price=[price] >>&Extension=[format .2f][quantityPrice][/format] >>[/append] >>[/lineItems] > >Ken, I got the same results. No cart number. Any other suggestions. I >fooled with all kinds of stuff tonight including trying a [setlineitem] >context, all to no avail. It's so close to what I want. Hope some one can >shed some light on it. > >Jerry Nielsen - comm$TRUCT Associates > > >Jerry N. Nielsen Voice: (626)351-0201 >comm$TRUCT Associates Fax: (626)351-0033 >Managing Consultant Cellular: (818)257-2937 >3835 Landfair Road >Pasadena, CA 91107 > >We con$TRUCT commerce sites that work the way YOU want them to! > >Thought for the day: The longest distance between to points is a shortcut. >^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ > > > > Sandra L. Pitner

DOWNLOAD WEBDNA NOW!

Top Articles:

Talk List

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...

Related Readings:

WebCat Talk Arhives... (1998) Cart questions (1997) Email Formatting (1998) How old am I? (2004) Country & Ship-to address & other fields ? (1997) Re:Change WebDNA-Talk Mail due to no digest for 1wk (1997) Nutscrape Doesn't Render Right (2002) Unknown exception in WebDNA 4.5.0 (2003) can WC render sites out? (1997) [OT] CSS and SSI books (2004) Return records from another (1997) Re:HTTP header line is too long? (1997) WebCatalog Upgrade Pricing? (1997) Search Folder? (1998) ftp to webstar (2001) Non Standard Product Display Layout (2000) unable to launch acgi in WebCat (1997) Upgrading 2.1 (2000) writing db to disk (1997) Running webdna on centos 4.2? (2006)