Re: many-to-one problem
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 17145
interpreted = N
texte = >One company.>One productlist, the pool.>50 trusted clients are allowed to buy online.>Not all clients can buy all products.>Not all clients should see all products.>Each client logs in with a password>...and gets his own price-list...>...for his preconfigured selection of products.>...and than he should walk around like in a common shop, controlled by his>access privilegues.Hi Peter,This will do everything you mentioned:1- Create a Products.db with ALL your products in it:productSKU (unique value)ProductIDCategoryTypeDescriptionHasPhotoPhoto-- any other fields you need2- Create a Clients.db with these fields:UniqueID (unique value)ClientID (same as the user value in this client's users.db record)SKU (same as the productSKU from the Products.db)PriceTaxable-- any other fields you need or that WebCatalog requires3- Create one record in the Clients.db for EACH Product.db record that client has access to.4- In the Users.db, create one record for each client:user (must be the same ClientID as in his/her Clients.db record -- all UPPERCASE)pass (any single string of characters, all UPPERCASE)groups (must include the word CLIENT in UPPERCASE letters)-- any other fields you need5- On all the pages that only your clients should have access to, put a [protect client] tag at the top of the page.6- On the page that searches for and displays all the items a particular client should have access to, write your search context like this:[search db=Clients.db&eqClientIDdatarq=[username]][founditems]***This is where each client will see ONLY the items he/shehas access to, based on his/her username/password .***[/founditems][/search]7- In any other searches you code into WebCatalog, always make sure to use the eqClientIDdatarq=[username] parameter in order to retrieve only the records for that particular client.Sincerely,Ken Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net
Associated Messages, from the most recent to the oldest:
>One company.>One productlist, the pool.>50 trusted clients are allowed to buy online.>Not all clients can buy all products.>Not all clients should see all products.>Each client logs in with a password>...and gets his own price-list...>...for his preconfigured selection of products.>...and than he should walk around like in a common shop, controlled by his>access privilegues.Hi Peter,This will do everything you mentioned:1- Create a Products.db with ALL your products in it:productSKU (unique value)ProductIDCategoryTypeDescriptionHasPhotoPhoto-- any other fields you need2- Create a Clients.db with these fields:UniqueID (unique value)ClientID (same as the user value in this client's users.db record)SKU (same as the productSKU from the Products.db)PriceTaxable-- any other fields you need or that WebCatalog requires3- Create one record in the Clients.db for EACH Product.db record that client has access to.4- In the Users.db, create one record for each client:user (must be the same ClientID as in his/her Clients.db record -- all UPPERCASE)pass (any single string of characters, all UPPERCASE)groups (must include the word CLIENT in UPPERCASE letters)-- any other fields you need5- On all the pages that only your clients should have access to, put a [protect client] tag at the top of the page.6- On the page that searches for and displays all the items a particular client should have access to, write your search context like this:[search db=Clients.db&eqClientIDdatarq=
[username]]
[founditems]***This is where each client will see ONLY the items he/shehas access to, based on his/her username/password .***[/founditems][/search]7- In any other searches you code into WebCatalog, always make sure to use the eqClientIDdatarq=
[username] parameter in order to retrieve only the records for that particular client.Sincerely,Ken Grome808-737-6499WebDNA Solutionsmailto:ken@webdna.nethttp://www.webdna.net
Kenneth Grome
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:
syntax question, not in online refernce (1997)
webcat restarting script on Linux? (1999)
Store Builder, technical infos (1998)
WebDNA Solutions ... (1997)
Intermitent problem using [referrer] (1997)
[WebDNA] Timer (2009)
WebSTAR, OSX, WebDNA permissions problem ... (2005)
More than one db with the same namn (was: WC2f3) (1997)
groups and [ShowNext] (1997)
database freeze (1997)
WebCat2 several catalogs? (1997)
Sendmail Enigma (2004)
Open Databases on Restart (1999)
Giving out error pages (1997)
[WebDNA] WebDNA 7 (2011)
Max Record length restated as maybe bug (1997)
WebCat2: Items xx to xx shown, etc. (1997)
2nd WebCatalog2 Feature Request (1996)
Hiding the URL(was Cart ID Duplication) (2001)
Emailer and encryption (1997)