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:

    
  1. Re: How can I record purchases to a database? (Jerry Nielsen 1998)
  2. Re: How can I record purchases to a database? (PCS Technical Support 1998)
  3. Re: How can I record purchases to a database? (Jerry Nielsen 1998)
  4. Re: How can I record purchases to a database? (PCS Technical Support 1998)
  5. Re: How can I record purchases to a database? (Jerry Nielsen 1998)
  6. Re: How can I record purchases to a database? (Chris Gursche 1998)
  7. Re: How can I record purchases to a database? (Sandra L. Pitner 1998)
  8. Re: How can I record purchases to a database? (Jerry Nielsen 1998)
  9. re: How can I record purchases to a database? (Kenneth Grome 1998)
  10. re: How can I record purchases to a database? (Jerry Nielsen 1998)
  11. How can I record purchases to a database? (Jerry Nielsen 1998)
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:

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)