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! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion 8 - Build next generation apps today, with easy PDF and Ajax features - download now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287738 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
