thanks David, it worked
>From: "Hayes, David" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: CF-Talk <[EMAIL PROTECTED]>
>Subject: RE: SQL question help
>Date: Tue, 7 Nov 2000 12:40:51 -0600
>
>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]
_________________________________________________________________________
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]
