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]
