Re: Logging purchases
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 11013
interpreted = N
texte = Kenneth Grome wrote:> > >Howdy, list. I would like to begin logging purchases from my thank you> >template through an [AppendFile purchlog.db] command. All I want is four> >fields: date, IP address, sku/item/quantity/price for each item> >purchased, and the total for that purchase. Anyone know how can I write> >[lineItems] into one field in a database without having the second line> >item create a new record?> > Hi Gil,> > Have you tried this? I don't know for sure, but I believe this will do what> you want. It shouldn't put any tabs or carriage returns inside the> lineitems loop, and the only other tabs and carriage returns are the ones> you type yourself.> > I used a series of dots to separate the individual lines of line items, but> you could replace those dots with something else, as long as it's not a tab> or carriage return ... :)Thanks, Ken. Actually, I was so hung up on using some kind of an ASCIIreturn character that when you suggested using ...., for some reason itmade me realize that I could just use HTML (as in
) to do what Iwant. Now the individual items break nicely within one cell of thetable.-- Gil Poulsen, Webmaster*************************************************************** AltiM@c * Phone: (908) 469-2567 ** 126 Jerome Avenue * FAX: (908) 469-5823 ** South Bound Brook, NJ * e-mail: help@altimac.com ** 08880-1111 * WWW: http://www.altimac.com ***************************************************************
Associated Messages, from the most recent to the oldest:
Kenneth Grome wrote:> > >Howdy, list. I would like to begin logging purchases from my thank you> >template through an [AppendFile purchlog.db] command. All I want is four> >fields: date, IP address, sku/item/quantity/price for each item> >purchased, and the total for that purchase. Anyone know how can I write> >
[lineitems] into one field in a database without having the second line> >item create a new record?> > Hi Gil,> > Have you tried this? I don't know for sure, but I believe this will do what> you want. It shouldn't put any tabs or carriage returns inside the> lineitems loop, and the only other tabs and carriage returns are the ones> you type yourself.> > I used a series of dots to separate the individual lines of line items, but> you could replace those dots with something else, as long as it's not a tab> or carriage return ... :)Thanks, Ken. Actually, I was so hung up on using some kind of an ASCIIreturn character that when you suggested using ...., for some reason itmade me realize that I could just use HTML (as in
) to do what Iwant. Now the individual items break nicely within one cell of thetable.-- Gil Poulsen, Webmaster*************************************************************** AltiM@c * Phone: (908) 469-2567 ** 126 Jerome Avenue * FAX: (908) 469-5823 ** South Bound Brook, NJ * e-mail: help@altimac.com ** 08880-1111 * WWW: http://www.altimac.com ***************************************************************
Gil Poulsen
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:
[WebDNA] ImageMagick troubleshooting (2009)
Comments in db? (1997)
Date calculation problems (1997)
Hello? (2004)
Looking for 5 to 12 shops with 3 URLs & statements (1997)
Dates (1998)
Relevancy Rating (1998)
WebCat2: Items xx to xx shown, etc. (1997)
[searchString] (1997)
japanese characters (1997)
Applescript, WebDNA, and PDF (1997)
SKU (1997)
Replace context problem ... and answers (1997)
Search Results (1998)
Time code! (2002)
Rendering out a page (1997)
Include vs. lookup? (1998)
CloseDataBase vs CommitDataBase (2007)
WebCatalog [FoundItems] Problem - AGAIN - (1997)
Sorting by SKU Not Working (1998)