For updating them it seems like a simple merge query would work fine enough, update if exists or it inserts if not. I have a series of custom functions I use in the database that help me deal with the need to do things like return a list of user permissions from a cross table. So in this case my function returns a comma seperated list of permissions, would be the same as doing a ValueList() in CF on the query results though.
On 3/17/06, Claude Schneegans <[EMAIL PROTECTED]> wrote: > > > Exactly! I do the same. > No need to query the database to check for a permission. Just put le > list in a session variable at login > and for every module, check if the permission code for the module is the > the user's list. > It is 1000 times (at least! ;-) simpler than having a cross table, > especially when editing the user's right. > Just one field to update instead of deleting all previous rights, then > adding new ones, even id no one has change. > > Unless users may have 1000s of different permissions, it is far simpler. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:235685 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54