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:

slow site (2003) [countWords]? (1997) International Orders (1998) $Quit, $CloseDatabase corrections (1997) how do I delete 1 of 2 identical records? (2003) WebCatalog can't find database (1997) Template Security error (1997) Adding Header Values with [SetHeader] (1998) A few questions. . . (1997) Sorting error (1997) Running _every_ page through WebCat ? (1997) Help! WebCat2 bug (1997) WebCat2b13MacPlugIn - [include] doesn't allow creator (1997) [Replace] (2000) ListFiles bug v3.0 OSX (2000) Major Security Hole IIS NT (1998) Longer .extensions with Windows? (1998) Frames (1997) cart info (1998) SV: Send massmail (2000)