>>Is it better to have the single varchar field in a given table like I'm doing, or is it better to create a seperate DB table to contain these data bits individually?
In theory, I mean in pure strict theory, you should take the second approach. But in common practice, especially if you have only a few possible parameters, the first approach can be much easier to work with, especially for updates. I handle permissions for users this way in my intranet system, they may be about 15 or 20 different kind of permissions, no more. You can even use a comma separated list, even easier to work with than with pipe characters. Also, instead of searching for an element in the list by SQL in a query, I store the whole list in a session variable once at login, and search for any specific element in the list whenever needed. -- _______________________________________ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2550 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
