Hello,

Let's say I have a list:
<cfset attributes.myList = "John, Amy">

How can I do a query that would take that list and do a not in?

<cfquery name="blah" ...>
select PKID
from myTable
where name not in ('#attributes.myList#')
</cfquery>

(This codes doesn't work)

CF 5.0


[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to