Thanks.
Thanks to everyone else that helped as well.
At 04:13 PM 10/7/2003 +0100, you wrote:
>something like
>
>
><cfquery name="blah" ...>
>select PKID
>from myTable
>where name not in (<CFQUERYPARAM VALUE="#attributes.myList#"
>CFSQLTYPE="CF_SQL_VARCHAR" LIST="Yes">)
></cfquery>
>
>
>altho make sure that there is something in the list... an empty list will
>throw an error
>
>
>HTH
>
>-----Original Message-----
>From: Won Lee [mailto:[EMAIL PROTECTED]
>Sent: Tuesday, October 7, 2003 16:06
>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]
