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 ASCII return character that when you suggested using ...., for some reason it made me realize that I could just use HTML (as in
) to do what I want. Now the individual items break nicely within one cell of the table.-- 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:

    
  1. Re: Logging purchases (Grant Hulbert 1997)
  2. Re: Logging purchases (Gil Poulsen 1997)
  3. Re: Logging purchases (Kenneth Grome 1997)
  4. Logging purchases (Gil Poulsen 1997)
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 ASCII return character that when you suggested using ...., for some reason it made me realize that I could just use HTML (as in
) to do what I want. Now the individual items break nicely within one cell of the table.-- 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)