> <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>
Check the ListQualify() function inside the docs
----------------------------
Massimo Foti
Certified Dreamweaver MX Developer
Certified Advanced ColdFusion MX Developer
http://www.massimocorner.com/
----------------------------
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
