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:

AccountAuthorizer doesn't seem to work (1997) $Replace with [founditems] (1997) redirect with frames (1997) OK, here goes... (1997) multiple price line in formula.db (2004) Multiple fields on 1 input (1997) Emailer (WebCat2) (1997) Search Combining Problem (2004) Webstar 1.3.1 PPC (1997) WebDNA Solutions ... (1997) how do we turn off staticpages page creation? (2003) [WebDNA] Brian Harrington (2019) different sized random banners (2003) Sample Tearoom Search Error (1997) RAM variables (1997) Loops N Variables (1998) Forcing Paragraph Breaks on Results (1998) Exclamation point (1997) Dreamweaver and WebDNA (2003) Sending Email (2004)