...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:23 AM
To: CF-Talk
Subject: RE: cfquery + list
We got a winner.
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]
