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, includingthe 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 throughoutthe year (% off sales, etc), and we weren't tracking the discount they werereceiving, I don't have a discount field in my database, so I can't use asimple [math] dealy to calculate what they paid.Any quick and dirty ways of parsing out the skus and prices from theorderfile lineitems??? I really *don't* want two dbs, one with the orderinfo, and one with the lineitems...L 0001 1 18.75 T F 0 Facial CleanserL 0003 1 33.75 T F 0 Facial Lotion Tanks, -- Will StarckNovaDerm Product and Technical Supporthttp://www.novaderm.comtechs@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:
I'd like all of my orderfiles written out to the same database, includingthe 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 throughoutthe year (% off sales, etc), and we weren't tracking the discount they werereceiving, I don't have a discount field in my database, so I can't use asimple [math] dealy to calculate what they paid.Any quick and dirty ways of parsing out the skus and prices from theorderfile lineitems??? I really *don't* want two dbs, one with the orderinfo, and one with the lineitems...L 0001 1 18.75 T F 0 Facial CleanserL 0003 1 33.75 T F 0 Facial Lotion Tanks, -- Will StarckNovaDerm Product and Technical Supporthttp://www.novaderm.comtechs@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)