As I said, I pretty much suck at SQL (and everything else if you believe
Bobby)
But you might try something like
WHERE PERMISSIONS LIKE '%#session.status#%'
-----Original Message-----
From: Hugh Fidgen [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 04, 2007 6:06 PM
To: CF-Talk
Subject: Re: SQL select where in headache
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!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Download the latest ColdFusion 8 utilities including Report Builder,
plug-ins for Eclipse and Dreamweaver updates.
http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287744
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
