Rick,
This
might be too convoluted to use, but you could build a weighting system to check
the From field.
If the
email address matches, they automatically have the email
used.
If
there is no email (no @ sign), then you attempt to parse out the words in the
from field (by searching for spaces, semicolons, and < > symbols that
sometimes surround the name or email)
Once
you have the individual parts, do a lookup on your database for first and last
names where the list of words from the from line are compared to the database
using either
the
'in' or 'like' statements in SQL.
You
might be able to create a weighting system where each word that matches counts,
and if you have only 1 'matching' person found then they are considered to be
the correct person.
Emails
that can't be matched using the secondary method could then be sent to your for
lookup/confirmation. Also, you could have these artificial matches sent to
you for confirmation. After confirming, build a secondary lookup table, or
an alternative column for the email address that includes a piece of the From
field. Future incoming emails would check the email address column first,
then the secondary lookup column.
I
doubt this would work if you have a massive number of
individuals.
Ryan
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Rick Eidson
Sent: Friday, February 22, 2002 8:32 AM
To: CF-List (E-mail)
Subject: [KCFusion] CFPOPI have been building an on-line community that is driven by emails.
I use CFPOP to check an email account and using the FROM I check the database to see if they are a member. My problem is that the FROM does not always contain an email address Just friendly name. Anyone know of another solution or a work around?
Rick Eidson
http://www.blueear.com
