On 10/7/2003 at 11:05, you wrote:
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
Maybe try "where not name in"
What database are you using?
~ Ubqtous ~
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
