>>why would you delete all previous permissions??? Because it is simpler than looking which one where removed, delete those ones, then look for which one where added and insert the new ones. This takes at least two loops.
>>If you are adding permissions a simple insert >>if you are taking away you just delete. Yeah, and if life was like that, you wouldn't need Visa... But in real life, some are added and some are deleted in the same form, and you don't know which ones, unless you wrtite the necessary code. >>I am not sure what experience you have Just a master degree in Computer Science, about 30 years in programming, about 15 years in database systems (I said 10, but it is really 15), and about 9 in CF. >> but in all my experience I have found doing anyhting with a comma delimnated list to bit me in the ass sooner or later Lack of experience, no doubt ;-) -- _______________________________________ 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:196653 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
