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:

writing db to disk (1997) Problems with [Applescript] (1997) How To question on setting up downloads (1997) WebCatalog can't find database (1997) For those of you not on the WebCatalog Beta... (1997) I'm new be kind (1997) Fun with dates (1997) Database Options (1997) serial number generation (1997) HELP WITH DATES (1997) Unable to view next 101-200 (1997) Seattle based Webcatters? (2000) Formatting date to number - more (2000) Searching the same field with 2 form variables. (2000) Bad merge format error message. (2004) suffix mapping for NT? (1997) [WebDNA] Friday's.. WIP thread (2009) Random letter and/or number (2001) Emailer problem....still (1997) color and size options / ARCHIVES (1997)