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:

Interpret twice? (1997) emailer (1997) [input] [/input] (1997) Bug or syntax error on my part? (1997) search form problem.. (1997) ErrorMessages.db suggestion (1997) .eml files (2001) 4.0.2b5 not finding databases under load (2000) Teaching Help! (2000) Busy WebCatalog (2000) Shopping Cart Problem (1998) Help name our technology! (1997) PCS Frames (1997) Include from DB (2002) [append] (1998) Quit revisited (1997) [shell] (2003) Webcat Manual and TeaRoom Examples Uses Different Examples. (1997) why do I get authorization requests, even though (1999) Sorting by date (1997)