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:
encryption madness (2003)
suffix mapping for NT? (1997)
Quick test - sorry (2004)
[ShowNext] (1997)
Just a thought (1998)
WebMerchant 1.6 and SHTML (1997)
.. more on sliding discounts... (1997)
FAX orders (1996)
WebCatalog Plug-in for Webstar. (1997)
HELP WITH DATES (1997)
Mac & Internet Explorer (2000)
can we get string variables? (1998)
URL for Discussion Archive (1997)
math problems (2000)
Problems with [Applescript] (1997)
HTML editing and webcatalog (2000)
OT: need bad code (2005)
can webcat determine an image's pixel dimensions? (2000)
Why WebMerchant not working? Please Help - More Info (1999)
What am I doing wrong? (2000)