Re: How can I record purchases to a database?
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 17836
interpreted = N
texte = Hi all,Earlier, I wrote>>[append db=NMI_Purchases.db] >>thisCart=[cart]&lineNum=[lineIndex]&Qty=[quantity]&SKU=[SKU]&ProdName=[Prod > PCS Support repsonded with>Youre not *really* putting a carriage return into the middle of that Append >context are you? So the first variable name is
thisCart=[cart]? If >you are, then that's the problem.That did it. I'm so used to formatting my HTML and WebDAN to make it easy to read, I didn't think about the fact that I was adding a return after the opening [append] tag by putting it on a new line. MANY THANKS!So o o o . . . for everyone who would like to record there purchases to a database, the syntax for the lien items in your order looks something like this.[lineitems] [append db=NMI_Purchases.db]thisCart=[cart]&lineNum=[lineIndex]&Qty=[quantity]&SKU= [SKU]&ProdName=[Prod Name]&Price=[price]&Extension=[format .2f][math][quantity]*[price][/math][/format][/append] [/lineItems]NOTE that the [append] context must be a single line of WebDNA.Thanks for your patience PCS support!Jerry NielsenJerry 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,Earlier, I wrote>>[append db=NMI_Purchases.db] >>thisCart=[cart]&lineNum=[lineIndex]&Qty=[quantity]&SKU=[SKU]&ProdName=[Prod > PCS Support repsonded with>Youre not *really* putting a carriage return into the middle of that Append >context are you? So the first variable name is thisCart=[cart]? If >you are, then that's the problem.That did it. I'm so used to formatting my HTML and WebDAN to make it easy to read, I didn't think about the fact that I was adding a return after the opening [append] tag by putting it on a new line. MANY THANKS!So o o o . . . for everyone who would like to record there purchases to a database, the syntax for the lien items in your order looks something like this.[lineitems] [append db=NMI_Purchases.db]thisCart=[cart]&lineNum=[lineIndex]&Qty=[quantity]&SKU= [SKU]&ProdName=[Prod Name]&Price=[price]&Extension=[format .2f][math][quantity]*[price][/math][/format][/append] [/lineItems]NOTE that the [append] context must be a single line of WebDNA.Thanks for your patience PCS support!Jerry NielsenJerry 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:
Bug or syntax error on my part? (1997)
tag request (1999)
2.0Beta Command Ref (can't find this instruction) (1997)
WebCommerce: Folder organization ? (1997)
Draft Manual, Tutorial, and more (1997)
Understanding texta (1997)
Signal Raised (1997)
authorizenet and netscape (2002)
Linux vs Jaguar (OSX) (2002)
wrong input values? (1997)
Big Databases (1997)
General WebCatalog Questions (1997)
WebCatalog/Mac 2.1b2 - PIXO (1997)
frustrated with search (2001)
RE: Credit card processing - UK (1997)
suffix mapping for NT? (1997)
Help name our technology! I found it (1997)
WebMerchant? (1998)
WC Database Format (1997)
Sum of [founditems] ? (2004)