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:

[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)