from myTable
where name not in (#attributes.myList#)
that's only if the values of attributes.myList is really a list.
you didn't need the 's (apostrophes) that's all.
...tony
tony weeg
senior web applications architect
navtrak, inc.
www.navtrak.net
[EMAIL PROTECTED]
410.548.2337
-----Original Message-----
From: Won Lee [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 07, 2003 11:06 AM
To: CF-Talk
Subject: cfquery + list
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]
