The problem with your code is that at the last list append, there would be a
comma at the end. :P Finally, the quotedvaluelist function sets your values
inside singlequotes.
do this
<cfset today = #createODBCDate(Now())#>
<cfquery name="getsurveys" datasource="#DSNa#">
SELECT semail FROM survey
</cfquery>
<Cfparam name="surveyemail" default="">
<Cfoutput query="getsurveys">
<cfset surveyemail = Listappend(surveyemail,semail)>
</CFOUTPUT>
<Cfquery name="todaysmembers" datasource="#DSNb#">
SELECT * FROM members
WHERE subscribe_date = #CreateODBCDate(DateAdd("d", -30, today))#
AND (email NOT in '#(QuotedValueList(surveyemail))#')
</CFQUERY>
>
><cfset today = #createODBCDate(Now())#>
>
><cfquery name="getsurveys" datasource="#DSNa#">
>SELECT semail FROM survey
></cfquery>
>
><Cfparam name="surveyemail" default="">
>
><Cfoutput query="getsurveys">
><cfset surveyemail = surveyemail & "#semail#,">
></CFOUTPUT>
>
><Cfquery name="todaysmembers" datasource="#DSNb#">
>SELECT * FROM members
>WHERE subscribe_date = #CreateODBCDate(DateAdd("d", -30, today))#
>AND (email NOT in '#surveyemail#')
></CFQUERY>
>
>
>Will
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
