well one way of doing this this would be to select existing email
addresses
from the database using a where clause that searches only for the email
address that you are looking for.
Then you can apply code that will deal with whether the the email
address
exists or not by checking the recordcount for the query.
e.g. <cfif queryname.recordcount is o>
the email address does not exist in the database
<cfelse>
the email address exists in the database
</cfif>
I'm not sure whether that is what you need. If you need to compare the
text
within the email use the compare/comparenocase functions
hth
mark
-----Original Message-----
From: Ben Densmore [mailto:[EMAIL PROTECTED]]
Sent: 27 December 2001 15:46
To: CF-Talk
Subject: looking for duplicate emails
Hi everyone,
can someone possibly tell me the best way to compare email addresses
that are allready in a database? Some of the info that my company gets
from customers may come from the same person but looking for 2
different
part numbers so I need to look for the email address and then compare
the part numbers and if they are the same the only show one of the
records, if the part numbers are different then show both.
Thank You,
Ben Densmore
______________________________________________________________________
Get Your Own Dedicated Windows 2000 Server
PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER
Instant Activation � $99/Month � Free Setup
http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb
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
