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=[ProdName]&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-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,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=[ProdName]&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-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:
Hide Ifs (2000)
WebCatalog for Mac 2.0.1 Released (1997)
Cancel Subscription (1996)
WC on Mac OS X or Mac OS X Server 2.x (2001)
You *can!!* overwrite username/password using an HTML form. Also, experts *please* see Q at end (2000)
[platform] tag? (1998)
WebCat2 - [format thousands] (1997)
[date format] w/in sendmail (1997)
showif and cart (1997)
AppleScript question (1997)
a new bug? (1999)
Only charge card when product shipped ? (1997)
REPOST: The old multiple selection bit (2000)
forgot the subject - apache/linux8/WC (2002)
Cant open pages generated by Webcat (2004)
Re:Emailer and encryption (1997)
Spawning Holdup? (2000)
test (2006)
Where do you put files? (2000)
Date Formats (1997)