Hiya, Sorry i think i've caused some confusion here.
#session.status# is always a single character, EG "P" "PERMISSIONS" is sometimes a single character, or sometimes a comma delimited list. It's populated via a <select multiple> input in a form, so it depends if the user selects one, or multiple options in the list. The typical values for PERMISSIONS column would be P or P,R or P,R,G Its a slightly cock-eyed way of doing it maybe, but it's how I thought i'd be able to establish if a user with #session.status# of "P" should be allowed to see the event in question. It might be that WHERE x IN y is not the best way of doing this but thats kinda where i need the help hehe. Thanks for all the input so far! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287736 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
