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:

WebDNA Developer Resource Center (2002) Stop the madness. (1997) How can I Add several Items into the cart at once? (1997) Setting up shop (1997) Still Stumped on ShowNext...HELP! (1997) Grep to convert characters to html entities (2006) HELP (2000) When will this BUG be fixed -- or at least LOOKED AT ... ? (2002) Post (1997) Need relative path explanation (1997) SSL with IIS 4.0 (1998) Max Record length restated as maybe bug (1997) more on quicktime test stuff (1997) Multiple Pulldowns (1997) 2.0Beta Command Ref (can't find this instruction) (1997) forms and variables (1998) Forbidden CGI Error (1997) Firewalls - What's Good? (1999) Almost a there but..bye bye NetCloak (1997) SKU lookup (1997)