many-to-one problem
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 17128
interpreted = N
texte = I have to setup a shop with one single product db and multiple client db's.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.The clue is to let our customer upload price-lists for his clients with different selections of ProductID's and individually units and prices and maintaining just one db with the actual product information.Starting point for each client is a sorted category-list with unique names. And there is the problem: I step through ProductID's of the client_x.db and find each associated Category in the product.db with a lookup. Then, of course, I get all found categories and not unique names...I tried to solve this problem by filtering out dup names with variables: I want set a variable oldcat to the found Category and a variable newcat to the new found Category. If the two match, skip that line... ---------- [search ...] (process all ProductID's in client_x.db) [interpret]oldcat=[/interpret] (initialize variable) [founditems] [interpret]newcat=[lookup ...][/interpret] (get Category in product.db) [hideif [[newcat]=[oldcat]]] (skip, if they match) [Category]
[/hideif] [interpret][newcat]=[oldcat][/interpret] (prepare for the next loop) [/founditems] [/search] ---------- I know, this use of [interpret] is nonsense, but how can I set a string variable? I manage to set variables with [math] but not with a string.Am I completely wrong with this database design for WebCat? If I put all stuff in one database I would get up to 200 fields. Or I put at least all clients names into the product database to have a client_x_HasProduct field, or duplicate the categories in the clients, which I don't like either... I could even write a setup program which combines all databases to a huge single one after something changes - please, donīt tell me that ;-)TIA, 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:
I have to setup a shop with one single product db and multiple client db's.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.The clue is to let our customer upload price-lists for his clients with different selections of ProductID's and individually units and prices and maintaining just one db with the actual product information.Starting point for each client is a sorted category-list with unique names. And there is the problem: I step through ProductID's of the client_x.db and find each associated Category in the product.db with a lookup. Then, of course, I get all found categories and not unique names...I tried to solve this problem by filtering out dup names with variables: I want set a variable oldcat to the found Category and a variable newcat to the new found Category. If the two match, skip that line... ---------- [search ...] (process all ProductID's in client_x.db)
[interpret]oldcat=[/interpret] (initialize variable)
[founditems] [interpret]newcat=[lookup ...][/interpret] (get Category in product.db) [hideif [[newcat]=[oldcat]]] (skip, if they match) [Category]
[/hideif]
[interpret][newcat]=[oldcat][/interpret] (prepare for the next loop) [/founditems] [/search] ---------- I know, this use of
[interpret] is nonsense, but how can I set a string variable? I manage to set variables with
[math] but not with a string.Am I completely wrong with this database design for WebCat? If I put all stuff in one database I would get up to 200 fields. Or I put at least all clients names into the product database to have a client_x_HasProduct field, or duplicate the categories in the clients, which I don't like either... I could even write a setup program which combines all databases to a huge single one after something changes - please, donīt tell me that ;-)TIA, 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:
I have troubles to send message out (1998)
WILDWEBCAT encrypt.tpl submission (1998)
Help! WebCat2 bug (1997)
search function (2005)
format_to_days on NT (1997)
[OT] Netscape Browser Window (2001)
Newbie: ASIP vs WebTen? (2000)
Banners (1997)
Showif probably dumb question (1997)
PIXO Support (1997)
Help with database strategy (1998)
WC2f3 (1997)
Processing all html files through WebCat or Typhoon (1998)
Problem with formatting dates stored in db (2003)
WebCat ignoring Shopping Cart Folder (2001)
Shipping charges depending on tax rate? (1997)
Re:Variable Math (1998)
Protect (1997)
Date or time comparisons have bugs ... (1998)
sort by day of week... (2003)