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:

WebDNA-Talk Digests (1997) Removing [showif] makes a big difference in speed (1997) change the number format (1997) Reversed words (1997) multiple databases (1997) [WebDNA] inputed text getting scrambled up in DB (2012) Date format problems (1997) Stinkin' [Referrer] (1998) Tag Corruption (2000) [searchString] (1997) Need help with search title (1998) pc (1997) [WebDNA] Email delivery problems? (2010) [WebDNA] Help with iTools 9/WebDNA setup MacTel (2009) Duplicate Carts (2006) Showif, Hideif reverse logic ? (1997) Hiding the URL(was Cart ID Duplication) (2001) Date Calulation (1997) flash-wc (2000) [WebDNA] New Product for WebDNA (2008)