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:
notification solutions (1997)
Occasional crashes with $remove (1997)
WebCommerce: Folder organization ? (1997)
Date math (1997)
JavaScript Image Problem (1998)
Setting up WebCatalog with Retail Pro data (1996)
WriteFile and returns... (2000)
Creating a back button (1999)
searchable list archive (1997)
Country & Ship-to address & other fields ? (1997)
WebCat & WebTen (1997)
Security for malls with different webmasters (1998)
WC2f3 (1997)
XML Parse with XML WebDNA Syntax... (2004)
Re:WebDNA Writer Needed (1997)
Major Security Hole IIS NT (1998)
[purgeDatabase], [replaceChars] and others ... (1997)
Timeout question .. (2003)
emailer (1997)
Calendar using WebCatalog? (1997)