When you are having trouble with a dynamic sql statement, output the
statement to the page to see what is actually being sent to the db.
Try replacing
tableB.email NOT IN ('#ValueList(getremovelist.email)#')
with
tableB.email NOT IN (#QuotedValueList(getremovelist.email)#)
Your SQL statement currently looks something like
NOT IN ('[EMAIL PROTECTED],[EMAIL PROTECTED],etc.')
and you want
NOT IN ('[EMAIL PROTECTED]','[EMAIL PROTECTED]',etc.)
-----Original Message-----
From: thanh nguyen [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 06, 2000 3:56 PM
To: CF-Talk
Subject: SQL question help
I want to do a filter , but somehow it does not the way i want it
I have a table that have email field , and onther table with a field email
who wants to remove from the list,
<cfquery name="getremovelist" datasource="remove" dbtype="ODBC">
select email from wantoremove
</cfquery>
<cfquery name="gettheList" datasource="BBB">
SELECT DISTINCT firstname, email
FROM tableB
WHERE
tableB.email NOT IN ('#ValueList(getremovelist.email)#')
</cfquery>
Somehow when i output the GettheList query , it still showing the emails
from the GetRemoveList query.
and datatype for email fields are varchar 100
please help
thanks
_________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Share information about yourself, create your own public profile at
http://profiles.msn.com.
----------------------------------------------------------------------------
--------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
