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:

Smart caching problems with 2.1b3? (1997) suffix mapping for NT? (1997) Grepping text variable tags (was: No subject given) (2000) Speed Optimization - Mac (1997) WebCatalog2 Feature Feedback (1996) Sendmail and textarea (1998) WebCat virtual postcard is done! Thanks for the help! (1998) format_to_days on NT (1997) WebCatalog Programmer looking for a new job (2001) question: webdelivery folder and file (1997) Search (1997) Pull Down Search (2000) RE: AccountAuthorizer doesn't seem to work (1997) WebCat editing, SiteGuard & SiteEdit (1997) [WebDNA] Retrieving a PDF from an email (2008) frames & carts (1997) Multiple fields on 1 input (1997) Frames and WebCat (1997) WCf2 and nested tags (1997) Dummy Credit Card Number for debug? (1997)