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:
[Semi-OT] Kinda cool tool (how does it work?) (2004)
Shopping Cart Best Practices (2006)
rotating thumbnails (1997)
BUG in [showif] using ^ (contains) (1997)
WC1.6 to WC2 date formatting (1997)
t or f (1997)
What if SSL server down? MAC (1997)
completed orders database (1997)
Templates for Customer Database? (1997)
Database Security (1998)
Pithy questions on webcommerce & siteedit (1997)
SSL and Webcat (2000)
HomePage Caution (1997)
writefile - continued (1997)
Emailer again & again (1997)
Secure server question (1997)
WebCat2 - [format thousands] (1997)
Ok here is a question? (1997)
Search Context: How to set Max=N? (2000)
Handy Browser Counter Tip (1997)