Why don't you use distinct
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 25 October 2001 05:12 To: CF-Talk Subject: <cf_filter_duplicate_emails_from_query> 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> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
