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:
Attention SMSI - DOCS Error (2004)
Error Template (1999)
Wanted: More Math Functions (or, Can You Solve This?) (1997)
[subtotal] problems -- help? (1998)
Database formats (2003)
Re:2nd WebCatalog2 Feature Request (1996)
# fields limited? (1997)
WebCatalog for guestbook ? (1997)
Emailer errors (1997)
HTML encoding in URLs (1997)
Sku numbers (1997)
WebCat2 - storing unformatted date data? (1997)
Line ending nuisance (2005)
This list needs a digest: rant, rave... (1997)
CERT Advisory on malicious scripts (2000)
[WebDNA] v6.2 dependencies? (2010)
WebCatalog2 Feature Feedback (1996)
[LOOKUP] (1997)
Web*3 virtual hosting Webcatalog problem (1998)
Separate SSL Server (1997)