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:
Search or delete (or date or time) has bugs ... (1998)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
more on quicktime test stuff (1997)
Snake Bites (1997)
passing the variable (1999)
WebCatalog for guestbook ? (1997)
Search inside Include (1998)
replace problem (1999)
emailer truncates last letter! (1997)
Serving images from databases (1998)
WebCatalog for Postcards ? (1997)
using showpage and showcart commands (1996)
Bug? (1997)
WebCat hosting providers? (1997)
Test! (2003)
serial number generation (1997)
Error Lob.db records error message not name (1997)
policies, slightly OT (2004)
Some pointers please (2008)
[movefile] (1999)