it's probably not working because each item in the list is not single quoted..
<cfset attributes.myList = "'John','Amy'"> that would work, no?
--
------------------------------------
Tuesday, October 7, 2003, 11:05:32 AM, you wrote:
WL> Hello,
WL> Let's say I have a list:
WL> <cfset attributes.myList = "John, Amy">
WL> How can I do a query that would take that list and do a not in?
WL> <cfquery name="blah" ...>
WL> select PKID
WL> from myTable
WL> where name not in ('#attributes.myList#')
WL> </cfquery>
WL> (This codes doesn't work)
WL> CF 5.0
WL>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
