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:

>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!

Re: How can I record purchases to a database?

1998

Top Articles:

Related Readings: