Re: Writing individual lineitems to a db

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 34374
interpreted = N
texte = >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...Why not? That's the most practical and efficient way to do it. How are you going to do it any other way? The orders.db stores one set of field data and the lineitems.db stores something completely different. The only thing they need to have in common is an order number. If you try to put all the lineitems in the orders.db, you're going to run into a situation where you run out of enough fields for the large number of lineitems in some orders, or else you're going to have lots of empty fields in MOST of your records simply to accommodate the orders with lots of lineitems in them. It's not that you can't do it, but why bother? ================================ Kenneth Grome, WebDNA Consultant 808-737-6499 http://webdna.net ================================------------------------------------------------------------- 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)
>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...Why not? That's the most practical and efficient way to do it. How are you going to do it any other way? The orders.db stores one set of field data and the lineitems.db stores something completely different. The only thing they need to have in common is an order number. If you try to put all the lineitems in the orders.db, you're going to run into a situation where you run out of enough fields for the large number of lineitems in some orders, or else you're going to have lots of empty fields in MOST of your records simply to accommodate the orders with lots of lineitems in them. It's not that you can't do it, but why bother? ================================ Kenneth Grome, WebDNA Consultant 808-737-6499 http://webdna.net ================================------------------------------------------------------------- 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/ 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:

Limiting user access to .tmpl files (1997) [defined]ish (1997) WebCat2b13 Mac plugin - [sendmail] and checkboxes (1997) Can ShowNext do this? (2000) WebMerchant & CC Response (2002) Text data with spaces in them... (1997) OT: Non US IP #'s (2003) writefile, csv, tab and excel import behavior (2004) Sort Order on a page search (1997) Search with Special Chars (1997) WebCat2b13MacPlugin - [math][date][/math] problem (1997) Re:Dumb Question about Docs (1997) customer.db and forms (1999) 2nd WebCatalog2 Feature Request (1996) Odd [math] behaviour (2003) WebCat2 - Getting to the browser's username/password data (1997) WebCatalog2 Feature Feedback (1996) ignore (test) (2000) Can you do this??? and other stuff (1997) shownext (2000)