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 Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net
Associated Messages, from the most recent to the oldest:
>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 Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://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)