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:

Re2: frames & carts (1997) Dark Horse Comics success story (1997) Using Cookie for client specific info? (1997) TEXTAREA and sendmail (1998) typhoon... (1997) WebDNA on Windows questions (2007) Moment of Thanks (1997) Protect (1997) Sorting nested search (2003) Anyone Using 4DMail (2004) SiteGuard Admin Feature ? (1997) Getting total number of items ordered (1997) Where's Cart Created ? (1997) Undeliverable Mail (1997) Security Tip (1996) [WebDNA] RE: webdna right click protect (2009) WebTen and WebCat (1997) More on the email templates (1997) [AppendFile] problem (WebCat2b13 Mac .acgi) (1997) PCS Frames (1997)