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:
WebCat b13 CGI -shownext- (1997)
Pixel Pipe & Auto Resizing of images (2002)
writing db to disk (1997)
Associative lookup style? + bit more (1997)
Cannot calculate prices (1997)
[WebDNA] Friday Fun with Variable Names (2017)
[ot] Setting up OS X To Serve To Windows (2004)
default value from Lookup (was Grant, please help me) (1997)
Help name our technology! I found it (1997)
search function (2005)
Summing fields (1997)
DBEdit (new version) available (2003)
webdelivery not working (1998)
Extended [ConvertChars] (1997)
SiteEdit Pro Update Announcement (1997)
more Dreamweaver Extensions feedback (2000)
SQL Madness (2005)
Re:Emailer and encryption (1997)
Error: Permision deny. Unable to append to'db=^WebMerchant/Stores.db' .Ignoring [Append] context (2002)
New to WebCat, Help. (1998)