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:
[isfile] ? (1997)
[LOOKUP] (1997)
WebCat2b13MacPlugIn - [include] doesn't allow creator (1997)
Cart Question (1998)
Re:listfiles-looking for slick solution (1997)
[WebDNA] Server vs FCGI version (2019)
Problems setting MIME Headers (1998)
problem with [Format Days_To_Date] (2000)
WebCatalog for guestbook ? (1997)
Multiple fields on 1 input (1997)
Extended [ConvertChars] (1997)
WebCat2b12--[searchstring] bug (1997)
Secure Server (1997)
Sorting problem (1997)
WebCatalog 2.0 & WebDNA docs in HTML ... (1997)
[WriteFile] problems (1997)
template includes encrypted template (1999)
Reversed words (1997)
SiteEdit NewFile.html ? (1997)
Waitfor file (2000)