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:

Next (1997) WebDNA on Intel Mac? (2006) RE: Loss in form (1998) Emailer Error 550 (Was Strange Crash) (1998) [WebDNA] sagepayments TLS? requests now failing (2018) Authorize.Net down 2 days in row (2004) Mac 2.1b4 unknown error: BadSuffix (1997) Re:2nd WebCatalog2 Feature Request (1996) multiple search commands (1997) [searchString] (1997) re:Clickable maps and WebCatalog? (1996) Can I invoke an ssi plugin from within a webcat page (1997) Add a field to the error log? (1997) RE: [WebDNA] Suddenly, lots of WebDNA problems with FastCGI (2013) emailer (1997) Merging databases (1997) Requiring that certain fields be completed (1997) Candle Light Vigil (2001) [OT] mozilla / Seamonkey (2007) triggers.db (1999)