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:

    
  1. Re: many-to-one problem (Kenneth Grome 1998)
  2. Re: many-to-one problem (Peter Ostry 1998)
  3. Re: many-to-one problem (PCS Technical Support 1998)
  4. Re: many-to-one problem (Kenneth Grome 1998)
  5. Re: many-to-one problem (Peter Ostry 1998)
  6. Re: many-to-one problem (Kenneth Grome 1998)
  7. Re: many-to-one problem (Peter Ostry 1998)
  8. Re: many-to-one problem (Kenneth Grome 1998)
  9. Re: many-to-one problem (Peter Ostry 1998)
  10. Re: many-to-one problem (Kenneth Grome 1998)
  11. many-to-one problem (Peter Ostry 1998)
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:

WC 2.0 frames feature (1997) WebCatalog can't find database (1997) Sending emails (went[ot] ) (2002) Showif for mulitple variations (1997) WebCatalog on Linux (2000) Re[2]: when is failing to [URL]ize values in a comparison ri (1999) Sendmail & Spell Checker (2001) [ShowNext] (1997) webcat & permissions (1999) sorting and summarizing (1998) [append] problem (1997) Problems with [Search] param - Mac Plugin b15 (1997) Help! WebCat2 bug (Ben's input) (1997) Fulfillment e-mail? (1998) WebDNA CAPTCHA (2008) unbreakable space on windows (2008) Speaking of... (1999) emailer (1997) searchable list archive (1997) More on the email templates (1997)