Re: How can I record purchases to a database?
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 17786
interpreted = N
texte = 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 91107We 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:
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 91107We 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. ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Jerry Nielsen
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:
success - serial numbers and webmerch (1997)
HELP - NONE STOP DIGESTS. Digest for 4/24/97) (1997)
emailer setup (1997)
Location of Browser Info.txt file (1997)
WC2b15 File Corruption (1997)
Email check problems (1999)
Fun with Dates - finally resolved but.... (1997)
Resume Catalog ? (1997)
SQL Connections (2004)
Webcat and other cgi (2000)
Preserving file creation dates on [copyfile] (2007)
What am I missing (1997)
two unique banners on one page (1997)
textarea to page display (1998)
unsubscribe (1997)
Requiring that certain fields be completed (1997)
[WebDNA] Help with iTools 9/WebDNA setup MacTel (2009)
Is there an easier way? (1998)
Multiple Newcarts (1996)
docs for WebCatalog2 (1997)