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:

Date and Time Math (1997) 2.0Beta Command Ref (can't find this instruction) (1997) [WebDNA] Image resizing on the fly (2012) OT: Flash developer needed (2007) [WebDNA] WebDNA development (2017) Auto conversion of URLs? (1998) [append] (1997) Almost a there but..bye bye NetCloak (1997) [WebDNA] Encode cookies ONLY via "method=Base64" (2008) autosensing lanague selection (1997) WebCat2b12 forgets serial # (1997) default value from Lookup (was Grant, please help me) (1997) getting images' width/height (1998) Apache suffix mapping for .tpl (1995) [WebDNA] Need someone to port CakePHP auction site to WebDNA (2010) Cart passing in Flash... (2001) Multi shift click (1999) GuestBook example (1997) Wanted: More Math Functions (or, Can You Solve This?) (1997) searchable list archive (1997)