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-0201comm$TRUCT Associates Fax: (626)351-0033Managing Consultant Cellular: (818)257-29373835 Landfair RoadPasadena, 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-0201comm$TRUCT Associates Fax: (626)351-0033Managing Consultant Cellular: (818)257-29373835 Landfair RoadPasadena, 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:
emailer error -108 (1997)
WebCat2b13MacPlugIn - More limits on [include] (1997)
Re:Emailer and encryption (1997)
pulldown menu differences (2005)
Writefile outside WebSTAR hierarchy? (1997)
Multiple transactions per cart (2000)
[WebDNA] grep question (2009)
Search and list the titles of book (2003)
Drop Down Menus (2002)
2nd WebCatalog2 Feature Request (1996)
SHOWNEXT (1999)
Help Encrypt/Decrypt eMail (2003)
shipping madness (2000)
FW: Shipping calculations (1997)
Frames and WebCat (1997)
how many users (2000)
WebCatalog can't find database (1997)
[sendmail] and [formvariables] (1997)
[LOOKUP] (1997)
WebSTAR/WebCat is serving .db files! (1999)