Re: many-to-one problem

This WebDNA talk-list message is from

1998


It keeps the original formatting.
numero = 17134
interpreted = N
texte = >I have to setup a shop with one single product db and multiple client db's. > >I need one main-database for >SKU, ProductID, Category, Type, Description, HasPhoto, Photo, >and many databases (one for each client) with >SKU, ProductID, ItemPrice, Unit, UnitPrice.Why not use a single client database?>If I put all stuff in one database I would get up to 200 fields.Seems to me that you would have only 5 fields -- the original 4 plus a new field named clientID, which would be used to identify which client each record belongs to ...Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net Associated Messages, from the most recent to the oldest:

    
  1. Re: many-to-one problem (Kenneth Grome 1998)
  2. Re: many-to-one problem (Peter Ostry 1998)
  3. Re: many-to-one problem (PCS Technical Support 1998)
  4. Re: many-to-one problem (Kenneth Grome 1998)
  5. Re: many-to-one problem (Peter Ostry 1998)
  6. Re: many-to-one problem (Kenneth Grome 1998)
  7. Re: many-to-one problem (Peter Ostry 1998)
  8. Re: many-to-one problem (Kenneth Grome 1998)
  9. Re: many-to-one problem (Peter Ostry 1998)
  10. Re: many-to-one problem (Kenneth Grome 1998)
  11. many-to-one problem (Peter Ostry 1998)
>I have to setup a shop with one single product db and multiple client db's. > >I need one main-database for >SKU, ProductID, Category, Type, Description, HasPhoto, Photo, >and many databases (one for each client) with >SKU, ProductID, ItemPrice, Unit, UnitPrice.Why not use a single client database?>If I put all stuff in one database I would get up to 200 fields.Seems to me that you would have only 5 fields -- the original 4 plus a new field named clientID, which would be used to identify which client each record belongs to ...Sincerely, Ken Grome 808-737-6499 WebDNA Solutions mailto:ken@webdna.net http://www.webdna.net 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:

FEW QUESTIONS (1997) Site Search Concepts (2003) Email (1998) Redirect (2003) Email Formatting (1998) View order not right (1997) Country & Ship-to address & other fields ? (1997) How to Sort Summ data ? (1997) problems with WebCat-Plugin (1997) Not reading code (1997) [WebDNA] Format Days_To_Date (2008) frames & carts (1997) shipping calculations, lookup command (1997) Separate SSL Server (1997) Here we go again... (2006) SiteGuard Use Question (1997) Running 2 two WebCatalog.acgi's (1996) [ReturnRaw] and hiding FORM data (2003) PCS Frames (1997) I'm new be kind (1997)