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:

HomePage Caution (1997) (2000) OLD ORDERS (1998) SQL statements (2002) Re:Emailer and encryption (1997) using showpage and showcart commands (1996) errormessages.db (1997) [/application] error? (1997) WebCat2b15MacPlugin - showing [math] (1997) date to days? (2005) [WebDNA] How to go into old WebCatalog? (2009) [WebDNA] parsing xml (2010) Security Hole - NetCloak Update (1998) PCS Frames (1997) Re2: frames & carts (1997) Updating fields from different platforms (1998) Bug Report, maybe (1997) WebCatalog as another user on mac osx (2001) How is it done? (1998) iTools and 3.0.8 (2000)