|
|
Dan,
This code errors out with the addition of: and membernumber not in
(<cfqueryparam list="yes" value="#valuelist(newsmember.membernumber)#
cfsqltype="cf_sql_integer">) . I cannot see the error because the host ISP has
verbose turned off.
<cfquery datasource="#application.ds#" name="newsMember">
SELECT distinct MemberNumber
FROM NetNewsTest
</cfquery>
<cfquery datasource="#application.dsrepl#" name="qryMember">
SELECT distinct Email,FirstName,LastName,MemberNumber
FROM members
WHERE memberstanding <= 2 AND email IS NOT NULL AND email <> ' '
and membernumber not in (<cfqueryparam list="yes"
value="#valuelist(newsmember.membernumber)# cfsqltype="cf_sql_integer">)
</cfquery>
<cfloop query ="qryMember">
<cfoutput>#qrymember.membernumber#</cfoutput>
insert into NetNewsTest (Email_address, First_Name, Last_Name, MemberNumber)
values ('#trim(qryMember.Email)#', '#trim(qryMember.FirstName)#',
'#trim(qryMember.LastName)#', '# trim(qryMember.MemberNumber)#')
</cfloop>
|
|