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:
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)