select PKID
from myTable
where name not in (<cfquery param value="#attributes.myList#" cfsqltype="cf_sql_varchar" list="yes">)
</cfquery>
Bryan Stevenson B.Comm.
VP & Director of E-Commerce Development
Electric Edge Systems Group Inc.
t. 250.920.8830
e. [EMAIL PROTECTED]
---------------------------------------------------------
Macromedia Associate Partner
www.macromedia.com
---------------------------------------------------------
Vancouver Island ColdFusion Users Group
Founder & Director
www.cfug-vancouverisland.com
----- Original Message -----
From: Won Lee
To: CF-Talk
Sent: Tuesday, October 07, 2003 8:05 AM
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]
