Hello,
I am querying 3 tables that all contain email addresses.
What I want to do is send an email using all the email
addresses. I just want to make sure there aren't
duplicate e-mail when i sent the email.
I need some advice on how to remove duplicates.
-------------------------------------------------------
i've got the cfquery ...
<CFQUERY NAME="all_emails" datasource="#datasource#">
SELECT db1_email,
db2_email,
db3_email
FROM db1,
db2,
db3,
</cfquery>
------------------------------------------
I need some advice on how to remove dupplicates
------------------------------------------
I've got the beginning of the cfloop/cfmail ...
<CFLOOP QUERY="all_emails">
<cfmail to="?" from="[EMAIL PROTECTED]"
subject="subject">
body
</cfmail>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
