I tried to write a query that get the list of emails and exclude the email
who wants to remove from the list
<cfquery name="getremovelist" datasource="DBAA" dbtype="ODBC">
select email from RemoveListrequest
</cfquery>
and this query to get the email list from the other database from different
server
<cfquery name="qryGetBrokerList" datasource="dbBB">
SELECT email
FROM emaillists
WHERE
emaillists.email NOT IN ('#ValueList (getremovelist.email)#')
ORDER BY lname
</cfquery>
but some how i still get the list with the email from query getremovelist
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]
