Re: [GROUPS] followup

This WebDNA talk-list message is from

1997


It keeps the original formatting.
numero = 11537
interpreted = N
texte = >We wanted to restrict catalog entry displays to only those who had group >access which matched that of the item to be displayed. In other words, >each item has a group associated with it and that group should be granted >access. The easiest solution would have been if there were a [groups] tag >like the global [UserName] tag to test against, but there isn't.> [foundItems] > [SHOWIF [lookup db=/webcatalog/users.db& > value=[Uppercase][UserName][/Uppercase]& > LookInField=user&returnfield=groups& > notFound=TextNotFound]^[PW_GROUP]] > ... > [/SHOWIF] > [/founditems]Yes, this looks like a great way to 'filter out' records that you don't want shown to certain people. A couple caveats: the [numfound] will be inaccurate in this case because you are hiding some of the records; this might get slow as the number of users or records increases, because you're doing a [lookup] every time you show a record.An example of this WebDNA technique for looking up groups can be found in the MultiGroupChecker and InGroup files that ship with WebCatalog.An alternative approach is to add a field to the database called PW_GROUP which contains the name of the group that is allowed to view this record. Then you can create a search that requires the person's group to match the PW_GROUP field in the database. This way the [numfound] is correct, and it could be faster...but I haven't tried it so there may be something I missed.Grant Hulbert, V.P. Engineering | ===== Tools for WebWarriors ===== Pacific Coast Software | WebCatalog Pro, WebCommerce Solution 11770 Bernardo Plaza Court | SiteEdit Pro, SiteCheck, PhotoMaster San Diego, CA 92128 | SiteGuard 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com Associated Messages, from the most recent to the oldest:

    
  1. Re: [GROUPS] followup (Grant Hulbert 1997)
  2. [GROUPS] followup (Sven U. Grenander 1997)
>We wanted to restrict catalog entry displays to only those who had group >access which matched that of the item to be displayed. In other words, >each item has a group associated with it and that group should be granted >access. The easiest solution would have been if there were a [groups] tag >like the global [username] tag to test against, but there isn't.> [founditems] > [SHOWIF [lookup db=/webcatalog/users.db& > value=[uppercase][username][/Uppercase]& > LookInField=user&returnfield=groups& > notFound=TextNotFound]^[PW_GROUP]] > ... > [/SHOWIF] > [/founditems]Yes, this looks like a great way to 'filter out' records that you don't want shown to certain people. A couple caveats: the [numfound] will be inaccurate in this case because you are hiding some of the records; this might get slow as the number of users or records increases, because you're doing a [lookup] every time you show a record.An example of this WebDNA technique for looking up groups can be found in the MultiGroupChecker and InGroup files that ship with WebCatalog.An alternative approach is to add a field to the database called PW_GROUP which contains the name of the group that is allowed to view this record. Then you can create a search that requires the person's group to match the PW_GROUP field in the database. This way the [numfound] is correct, and it could be faster...but I haven't tried it so there may be something I missed.Grant Hulbert, V.P. Engineering | ===== Tools for WebWarriors ===== Pacific Coast Software | WebCatalog Pro, WebCommerce Solution 11770 Bernardo Plaza Court | SiteEdit Pro, SiteCheck, PhotoMaster San Diego, CA 92128 | SiteGuard 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com Grant Hulbert

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:

[WebDNA] New problem with [ShowNext] (2010) Cart Unique After Rolling Back Time? (2001) [SubTotal] ??? (1998) Micro-managing External Links (2006) Rhapsody? (1997) Emailer port change (1997) RE: protect tag on NT (1997) removing commas from a preformatted number (2000) Displaying text and populating form fields (2005) [WebDNA] Problem with Cookies in IE and Safari (2009) Search design (1997) WebCat2b13MacPlugIn - more [date] problems (1997) WebDNA tags in WebMerchant email templates ... (1997) Upcoming 2.1 Release and PCS Committment (1997) First Attempts (2000) Order not created error (never mind) (1997) [WebDNA] Installing WebDNA on VPS (2008) File Upload (1997) [purchase] (1999) Re:Email Problem (1997)