Re: many-to-one problem
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 17190
interpreted = N
texte = (Kenneth Grome:) >1- Create a Products.db with ALL your products >... >2- Create a Clients.db >... >3- Create one record in the Clients.db for EACH Product.db record that client has access to. Thanks, Kenneth, for your suggestions. It works (of course ;-) for the access restriction. But it does not solve the second problem: when I search for the client I get a list of all his products. In [founditems] I loop through the product-sku's of the client and find associated categories in products.db with lookups. But because WebCat has no string variables :-( I cannot skip double names within the loop and therefore can't get unique values for a category list:search clients.db for username [founditems] lookup products.db for SKU, return CATEGORY [/founditems] [/search]This returns a list of all categories, but with dup names.--------------------I solved this finally with a temporary database. I write all found categories into a temporary database file:search clients.db for username writefile: temp.db appendfile temp.db: SKU CATEGORY [founditems] appendfile temp.db: lookup products.db for SKU, return CATEGORY [/founditems] [/search]And now I search the created temp.db and get my unique values via the CATEGORYsumm command:search temp.db with CATEGORYsumm=t [founditems] [CATEGORY]
[/founditems] [/search] [closedatabase temp.db]That's it! This method is fast enough for my application since it is a frame version and the category list is generated just once, when the clients logs in.--------------------BTW - I discovered some strange behavior: [appendfile somefile]sometext[/appendfile] does not put a carriage return at the end of the line, I have to write it like this: [appendfile somefile]sometext [/appendfile] (I use BBEdit 4.5)Peter__________________________________________ Peter Ostry - po@ostry.com - www.ostry.com Ostry & Partner - Ostry Internet Solutions Auhofstrasse 29 A-1130 Vienna Austria fon ++43-1-8777454 fax ++43-1-8777454-21
Associated Messages, from the most recent to the oldest:
(Kenneth Grome:) >1- Create a Products.db with ALL your products >... >2- Create a Clients.db >... >3- Create one record in the Clients.db for EACH Product.db record that client has access to. Thanks, Kenneth, for your suggestions. It works (of course ;-) for the access restriction. But it does not solve the second problem: when I search for the client I get a list of all his products. In
[founditems] I loop through the product-sku's of the client and find associated categories in products.db with lookups. But because WebCat has no string variables :-( I cannot skip double names within the loop and therefore can't get unique values for a category list:search clients.db for username
[founditems] lookup products.db for SKU, return CATEGORY [/founditems] [/search]This returns a list of all categories, but with dup names.--------------------I solved this finally with a temporary database. I write all found categories into a temporary database file:search clients.db for username writefile: temp.db appendfile temp.db: SKU CATEGORY
[founditems] appendfile temp.db: lookup products.db for SKU, return CATEGORY [/founditems] [/search]And now I search the created temp.db and get my unique values via the CATEGORYsumm command:search temp.db with CATEGORYsumm=t
[founditems] [CATEGORY]
[/founditems] [/search] [closedatabase temp.db]That's it! This method is fast enough for my application since it is a frame version and the category list is generated just once, when the clients logs in.--------------------BTW - I discovered some strange behavior: [appendfile somefile]sometext[/appendfile] does not put a carriage return at the end of the line, I have to write it like this: [appendfile somefile]sometext [/appendfile] (I use BBEdit 4.5)Peter__________________________________________ Peter Ostry - po@ostry.com - www.ostry.com Ostry & Partner - Ostry Internet Solutions Auhofstrasse 29 A-1130 Vienna Austria fon ++43-1-8777454 fax ++43-1-8777454-21
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 editing, SiteGuard & SiteEdit (1997)
Listfiles on network with NT (2000)
[WebDNA] Fresh Snow Leopard install (2009)
Alternative colors? (2000)
Bug alert! (1997)
Sendmail on OSX/Communigate Pro (2002)
all records returned. (1997)
[OT] (waaaay OT) (2004)
Using [Include] Context (1999)
[include ...] behavior (1997)
funky values using [fileinfo] (2001)
[WebDNA] Downloadable docs (2011)
Math with Time (1997)
WebCat 4.0.1 (2000)
Help with getting rpm file (2002)
Error Lob.db records error message not name (1997)
RE: [WebDNA] Sorry WebDNA server not running /Template ERROR/ Slow (2019)
Associative lookup style? + bit more (1997)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
WebDNA Intranet Edition public demo (2002)