Permissions is not a list...the IN statement allows you to pass a list
of parameters, so for instance if you had a statement "where id
in(1,2,3,4)" it would get the records for all records in that table with
id's of 1,2,3,or 4. If the values are varchar's...then each element
needs single quotes around it ie..('x','y','z') but numeric types do
not.
Eric
> -------- Original Message --------
> Subject: RE: SQL select where in headache
> From: "Dave Francis" <[EMAIL PROTECTED]>
> Date: Tue, September 04, 2007 2:22 pm
> To: CF-Talk <cf-talk@houseoffusion.com>
>
> I don't know the answer (my SQL is very, very basic), but the way I read it
> is he is saying the PERMISSIONS column in the db is also sometimes a list.
>
> Best advice I have is to normalize the db first.
>
>
>> Unsubscribe:
>> http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=20022.5277.4
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Check out the new features and enhancements in the
latest product release - download the "What's New PDF" now
http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:287726
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
