Re: Logging purchases

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 11008
interpreted = N
texte = >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 ... :)[AppendFile purchlog.db][date][ipAddress][lineitems][sku]/[item]/[quantity]/[price ].....[/lineitems][total][/appendfile]Sincerely, Ken Grome ..... ken@iav.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)
>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 ... :)[AppendFile purchlog.db][date][ipaddress][lineitems][sku]/[item]/[quantity]/[price ].....[/lineitems][total][/appendfile]Sincerely, Ken Grome ..... ken@iav.com Kenneth Grome

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:

syntax question, not in online refernce (1997) New syntax feedback for 4.0 (2000) WebCat2b13MacPlugIn - More limits on [include] (1997) Showing unopened cart (1997) .html with IIS4 (1999) 2cd pair of eyes (2003) WebCat2: multiple currency support (1997) Here's how to kill a Butler Database. (1997) Problems getting parameters passed into email. (1997) redirect with frames (1997) multi-paragraph fields (1997) [delete] problem (1997) Emailer setup (1997) expired beta (1997) Getting total number of items ordered (1997) Banners (1997) CommandSecurity? (1997) wierd [cart] action! (1997) Orders coming up blank (2004) Separate SSL Server (1997)