>>using a list requires fetching data, parsing it, and then fetching
more data.
Depends how you do it:
1- when a user logs in, get his permission list from into a session
variable from the same query as other user parameters.
2- in any template a user permission needs to be checked, just do
<CFIF listFind(currentPermission, session.permissionList)>
that's it.
3- when editing permissions, just use a select box multiple or check boxes
4- when updating, just replace one field in the user record with the
new value of the list, PERIOD.
Doing the same thing with a join table:
1- when a user logs in, get his permission list from an query using a
JOIN and convert the permission column into a list using valueList().
2- same as above
3- same as above
4- when updating, you have to delete first all previous permissions for
that user from the table, then insert all new records.
When there are only a few hundreds enployees and a few tens permission
to control, I'd say that a programmer who insists
on using method 2 instead of 1 has his skill based on theory, not on
experience.
If ever the company grows up to thousands employees and need hundreds of
permissions, they will most probabily need
user groups, permission levels and a completely permission scheme any way.
--
_______________________________________
REUSE CODE! Use custom tags;
See http://www.contentbox.com/claude/customtags/tagstore.cfm
(Please send any spam to this address: [EMAIL PROTECTED])
Thanks.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:196637
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=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
