Re: many-to-one problem
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 17136
interpreted = N
texte = At 9:53 Uhr -1000 20.04.1998, Kenneth Grome wrote:>>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. > >>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 ... No, there are 1000 products and each client has a selection of them and his own pricing which depends on special agreements. In short: sku id cat type desc c1a c1b c1c.......c50a c50b c50c 1 20 10L 200 15 3L 45 2 25 2G 50 3 20 10L 200 30 5L 150 4 3 1X 3 5 6 5X 30 8 5X 40So if I put all 50 clients in one db I will get 50x3=150 fields for clients plus the main product-fields. They are occasional clients, therefore 50 single databases would be better (never more than 1 or 2 open) and are easy to maintainance for our customer - if there where not the previous decribed problem: With single db's (1 product.db and 50 client.db's) I cannot display a category list for a single client when I don't have the categories there. If I step through the client's products and do a search in the main database for each product the result is a list with duplicate names and very low performance. And if I duplicate the categories then I have already 2 fields duplicated which would mean a great deal of external processing when one uploads a new db...Doing the broad thing? I believe that WebCat can handle a 200x1000 database, but the customer can't... Am I fighting with the wrong program for this special setup - or is there a technique with WebCat I did not find out yet?Peter__________________________________________ Peter Ostry Ostry & Partner - Ostry Internet Solutions Auhofstrasse 29 A-1130 Vienna Austria fon ++43-1-877 74 54 fax ++43-1-877 74 54 po@ostry.com _______________ www.ostry.com
Associated Messages, from the most recent to the oldest:
At 9:53 Uhr -1000 20.04.1998, Kenneth Grome wrote:>>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. > >>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 ... No, there are 1000 products and each client has a selection of them and his own pricing which depends on special agreements. In short: sku id cat type desc c1a c1b c1c.......c50a c50b c50c 1 20 10L 200 15 3L 45 2 25 2G 50 3 20 10L 200 30 5L 150 4 3 1X 3 5 6 5X 30 8 5X 40So if I put all 50 clients in one db I will get 50x3=150 fields for clients plus the main product-fields. They are occasional clients, therefore 50 single databases would be better (never more than 1 or 2 open) and are easy to maintainance for our customer - if there where not the previous decribed problem: With single db's (1 product.db and 50 client.db's) I cannot display a category list for a single client when I don't have the categories there. If I step through the client's products and do a search in the main database for each product the result is a list with duplicate names and very low performance. And if I duplicate the categories then I have already 2 fields duplicated which would mean a great deal of external processing when one uploads a new db...Doing the broad thing? I believe that WebCat can handle a 200x1000 database, but the customer can't... Am I fighting with the wrong program for this special setup - or is there a technique with WebCat I did not find out yet?Peter__________________________________________ Peter Ostry Ostry & Partner - Ostry Internet Solutions Auhofstrasse 29 A-1130 Vienna Austria fon ++43-1-877 74 54 fax ++43-1-877 74 54 po@ostry.com _______________ www.ostry.com
Peter Ostry
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:
off topic - dna snipets (1997)
Silly Question (1997)
[WebDNA] feature suggestion (2011)
Stopping bad HTML propagation ? (1997)
Appending Information from one db to another (1998)
[isfile] ? (1997)
Separate SSL Server (1997)
[delete] problem (1997)
Show next 2 examples that work (1997)
[WebDNA] Fails to recognize comma-separated db (2010)
Running _every_ page through WebCat-error.html (1997)
More questions about serial number dishing (1997)
HTML Editors (1997)
WebCat 3.04-3.07 plug-in dying on server.... (2000)
Bug Report, maybe (1997)
WebDNA / Red Hat 9 ? (2003)
Help: Append context problems (1999)
WebDNA-Talk Digests (1997)
Word search (1997)
AOL and [redirect] (2000)