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:

Archives (2001) Security (1998) WC2b12: Yes, Formulas.db is for real (1997) WebCat2: Master Counter snippet (1997) WebCommerce: Folder organization ? (1997) Random question (1998) searching multiple databases (1997) Separate SSL Server (1997) Public beta 4 of WebCatalog 4.0 is now available (2000) HELP!! problems with e-mail from WebCAT (1998) RE: How much ram??? (1997) where did it find it? part 2 (2000) HELP WITH DATES (1997) [WebDNA] WebDNA 6.1 Info (2008) Mac: LModelDirector bug fix (1997) Attention all list readers (1997) Problems getting parameters passed into email. (1997) Multi-processor Mac info ... (1997) WebMerchant 1.6 and https (1997) Anyone have a register your domain app? (2000)