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:
WC2.0 Memory Requirements (1997)
Support ?? (1997)
Search Engine bots (2002)
tricky embedded[showifs/hideifs] (w/ code.. long) (2000)
emailer settings and control questions (1997)
WebCat virtual postcard is done! Thanks for the help! (1998)
WebCat2b13MacPlugin - [math][date][/math] problem (1997)
URGENT! Locked DB's (2001)
WebCat/CyberStudio Compatibility (1998)
Add to a field (1998)
too many nested tags ... (1997)
Math inside [showif] (1998)
How do I get Google to crawl a WebCat site? (2003)
Emailer problem with WC 2.1, NT, WebSite 2.1 (1998)
WebCat2 several catalogs? (1997)
How flexible is Shipping? (1997)
Date Calulation (1997)
Not reading code (1997)
Selecting sort fields (2000)
Re:no [search] with NT (1997)