Re: I'm Baaaaaaaaaack - Questions!
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 32318
interpreted = N
texte = each SKU record has a section field naming which of the 3 sections it belongs to (type-A,B or C), so you can easily find and sort just the records belonging to one of the 3 sections.A 2nd RemoteUser.db has these fields: RemoteUserName, RemoteUserPass, RemoteUserGroups. Make sure all data in this db is uppercase. You add a record for a user every time he should belong to another group. There's a group for each of the 3 sections. So if 22 people can see/edit type-A products, then that is 22 more records in this db. So if user Fred should be able to access type-A products and also type-C (but not type-B), then that is 2 records in this db:Fred
DinoIsHisPasswordtype-A FredDinoIsHisPasswordtype-CThe on the page where the user clicks the section he wants to see/edit (page-1), you have it goto page-2 while passing a variable- 'YourFormVar=type-A' (or whatever type product he wants)On page-2 you use [search] context to show just type-A records from the product.db, *BUT* above that [search] you put this- [include file=inc-Frenzelprotect.txt&raw=F&groups=[YourFormVar]-------- Start inc-Frenzelprotect.txt ---------- [showif NotFound=[lookup db=RemoteUser.db&lookinField=RemoteUserName&value=[uppercase][username][/uppercase]&returnField=RemoteUserName¬Found=NotFound]][authenticate Who is that] [/showif] [showif [url][uppercase][password][/uppercase][/url]![url][lookup db=RemoteUser.db&lookinField=RemoteUserName&value=[uppercase][username][/uppercase]&returnField=RemoteUserPass¬Found=NotFound][/url]][authenticate What's your password] [/showif] [search db=RemoteUser.db&wsRemoteUserGroupsdatarq=[uppercase][groups][/uppercase]&eqRemoteUserNamedatarq=[uppercase][username][/uppercase]&eqRemoteUserPassdatarq=[url][uppercase][password][/uppercase][/url]][showif [numFound]=0] [authenticate Unknown Group] [/showif] [/search]-------- End inc-Frenzelprotect.txt ----------This is just off the top of my head. I don't know who to credit for that include. There may be easier ways, or better ways... Heck maybe this won't even work. That's all the time I have now. (Hopefully I helped)-JohnTony Frenzel wrote:> I have a client who wants the following - how would I go about this: > > Passwords and Different Level Access > > There will be three sections of products. My client wants it so that when > a user clicks on a section, before the products come up there pops up a > user name and password entry thing. The catch is, it has to happen for all > three sections and there must be different levels of access. For example, > one person might have access to sections A and B, while another B and C, or > just A. My client has 40 different users who need all different > combinations of access. How do I go about doing this? > > Any help would be MUCH apreciated! > > Best regards, > > Tony Frenzel > IDK > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > Web Archive of this list is at: http://search.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
each SKU record has a section field naming which of the 3 sections it belongs to (type-A,B or C), so you can easily find and sort just the records belonging to one of the 3 sections.A 2nd RemoteUser.db has these fields: RemoteUserName, RemoteUserPass, RemoteUserGroups. Make sure all data in this db is uppercase. You add a record for a user every time he should belong to another group. There's a group for each of the 3 sections. So if 22 people can see/edit type-A products, then that is 22 more records in this db. So if user Fred should be able to access type-A products and also type-C (but not type-B), then that is 2 records in this db:FredDinoIsHisPasswordtype-A FredDinoIsHisPasswordtype-CThe on the page where the user clicks the section he wants to see/edit (page-1), you have it goto page-2 while passing a variable- 'YourFormVar=type-A' (or whatever type product he wants)On page-2 you use [search] context to show just type-A records from the product.db, *BUT* above that [search] you put this- [include file=inc-Frenzelprotect.txt&raw=F&groups=[YourFormVar]-------- Start inc-Frenzelprotect.txt ---------- [showif NotFound=[lookup db=RemoteUser.db&lookinField=RemoteUserName&value=[uppercase][username][/uppercase]&returnField=RemoteUserName¬Found=NotFound]][authenticate Who is that] [/showif] [showif [url][uppercase][password][/uppercase][/url]![url][lookup db=RemoteUser.db&lookinField=RemoteUserName&value=[uppercase][username][/uppercase]&returnField=RemoteUserPass¬Found=NotFound][/url]][authenticate What's your password] [/showif] [search db=RemoteUser.db&wsRemoteUserGroupsdatarq=[uppercase][groups][/uppercase]&eqRemoteUserNamedatarq=[uppercase][username][/uppercase]&eqRemoteUserPassdatarq=[url][uppercase][password][/uppercase][/url]][showif [numFound]=0] [authenticate Unknown Group] [/showif] [/search]-------- End inc-Frenzelprotect.txt ----------This is just off the top of my head. I don't know who to credit for that include. There may be easier ways, or better ways... Heck maybe this won't even work. That's all the time I have now. (Hopefully I helped)-JohnTony Frenzel wrote:> I have a client who wants the following - how would I go about this: > > Passwords and Different Level Access > > There will be three sections of products. My client wants it so that when > a user clicks on a section, before the products come up there pops up a > user name and password entry thing. The catch is, it has to happen for all > three sections and there must be different levels of access. For example, > one person might have access to sections A and B, while another B and C, or > just A. My client has 40 different users who need all different > combinations of access. How do I go about doing this? > > Any help would be MUCH apreciated! > > Best regards, > > Tony Frenzel > IDK > > ------------------------------------------------------------- > This message is sent to you because you are subscribed to > the mailing list . > To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > Web Archive of this list is at: http://search.smithmicro.com/ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
John Butler
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:
Grep help (2004)
[isfile] ? (1997)
[WebDNA] improvements (2015)
Price Not Appearing (2000)
combine search (1998)
the dreaded unitShipCost (2003)
MacActivity and PCS (1997)
Editing only the price field in the database (1998)
WebCat2b15MacPlugin - [protect] (1997)
Re2: frames & carts (1997)
all records returned. (1997)
any WEBCAT gurus who are also PERL proficient? (1999)
File Upload Problems (HELP!) (2000)
WebCatalog Beta Documentation (1997)
A quickie question (1997)
Error with [applescript] (1999)
Too Much Rootbeer Free Offer (1997)
slow site (2003)
Edit field in orderfile (2002)
HTTP upload (2000)