SELECT DISTINCT field FROM table Where field contains the field where youe e-mail addresses are.
-Justin Scott, Lead Developer Sceiron Internet Services, Inc. http://www.sceiron.com ----- Original Message ----- From: "Dan Sullivan" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, October 23, 2001 4:47 PM Subject: <cf_filter_duplicate_emails_from_query> > hi, > > I am querying more than one table that all contain email addresses. > I am merging all of these e-mail addresses into a CFMAIL email blast > of all the email addresses. I need advice on how to make sure there > aren't duplicate e-mail addresses after all the e-mails are merged > and the email is lopped through each e-mail address. > > Should I use a list and check against the list before adding to the list? > > i've got the cfquery working ... > > I need the e-mail duplicate validation 8-) > > i've got the cfloop/cfmail working ... > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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
