Writing individual lineitems to a db

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 34371
interpreted = N
texte = I'd like all of my orderfiles written out to the same database, including the lineitem skus and values, something like:ordernum,orderdate,name,email,address... ...sku1,price1,sku2,price2 etc.(, = )Since different customers pay various prices for the same item throughout the year (% off sales, etc), and we weren't tracking the discount they were receiving, I don't have a discount field in my database, so I can't use a simple [math] dealy to calculate what they paid.Any quick and dirty ways of parsing out the skus and prices from the orderfile lineitems??? I really *don't* want two dbs, one with the order info, and one with the lineitems...L 0001 1 18.75 T F 0 Facial Cleanser L 0003 1 33.75 T F 0 Facial Lotion Tanks, -- Will Starck NovaDerm Product and Technical Support http://www.novaderm.com techs@novaderm.com ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Writing individual lineitems to a db (Kenneth Grome 2000)
  2. Writing individual lineitems to a db (Will Starck 2000)
I'd like all of my orderfiles written out to the same database, including the lineitem skus and values, something like:ordernum,orderdate,name,email,address... ...sku1,price1,sku2,price2 etc.(, = )Since different customers pay various prices for the same item throughout the year (% off sales, etc), and we weren't tracking the discount they were receiving, I don't have a discount field in my database, so I can't use a simple [math] dealy to calculate what they paid.Any quick and dirty ways of parsing out the skus and prices from the orderfile lineitems??? I really *don't* want two dbs, one with the order info, and one with the lineitems...L 0001 1 18.75 T F 0 Facial Cleanser L 0003 1 33.75 T F 0 Facial Lotion Tanks, -- Will Starck NovaDerm Product and Technical Support http://www.novaderm.com techs@novaderm.com ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/ Will Starck

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:

Error Log.db --however (1997) EmailFolder Correct Permissions ? (2003) Is this possible, WebCat2.0 and checkboxes (1997) Post arguments problem mac? (1997) Bulk Email >>>>Any ideas? (2001) Help! WebCat2 bug (1997) [url] (1997) [WebDNA] DNA suffix (2008) Is [thisurl] http or https? (1998) &fieldsdir=ra truely random?? (2000) Country & Ship-to address & other fields ? (1997) includes and cart numbers (1997) Mac Vs WindowsNT (1997) Looping control (1997) WebCat2b12 CGI Mac - [shownext] problem (1997) [random] only for 1-100??? (1997) using showpage and showcart commands (1996) EmailProblem (2003) All choices on IE different than Netscape (1997) Targeted Redirect (1999)