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:
WSDL Web services design wizard (2005)
WordBreak Qestion (part 2) (1998)
RE: [sendmail]- bcc? (1998)
UPDATE PROBLEM (1997)
NT or Mac (1998)
BUG in [showif] using ^ (contains) (1997)
Separate SSL Server (1997)
Webcat 2.0.1b1 bug with IE 3.01/4.0p1 (1997)
Banners (1997)
searchable list archive (1997)
Q: for those who use Cookies for sessions? (2004)
WebCat2 Append problem (B14Macacgi) (1997)
It just Does't add up!!! (1997)
different show next (1997)
WebCatalog 2.0 & WebDNA docs in HTML ... (1997)
Separate server for jpg/gif files (1998)
Days in range (2002)
[WebDNA] webdna email breaking (2011)
[OT] Trying to steal databases on our server (2003)
Developers in Washington State (2004)