Erika,
If you don't mind me plugging my own product, cfx_kmSuite contains a couple
of functions that might help. If you could store your company names in a CF
list, the "cfx_kmList.ListBestMatch" function could be used to resolve user
input to an existing company name. Another option would be to use the
"cfx_kmMisc.Soundex" function to build soundex values for each company name.
You could compare the soundex of the user input to the stored soundex
values.
cfx_kmSuite adds more than 100 functions to Cold Fusion. I try hard to
keep my customers happy. If there's something you want that isn't in the
product, I'll try to add it.
Documentation and purchase info for cfx_kmSuite at:
http://www.hoptechno.com/kmtools/
Keith Meade
[EMAIL PROTECTED]
----- Original Message -----
From: "Erika L. Walker" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, May 10, 2001 10:52 AM
Subject: OT: Data Integrity - Q of the Day
: Here's a question that's been bothersome for some time.
:
: We have an interface where participants register for meeting. There is a
: form they fill out with basic information, including the pharmaceutical
: company they are associated with.
:
: We use drop downs where we can to keep data as constant as possible, but
we
: cannot use dropdowns for the company they are with as there are far too
many
: to compile and list.
:
: And therein lies our problem. Users from one company can have a half dozen
: different ways to spell their company name.
:
: There is an admin search page where an administrator can search for
: registered users by several different criteria, one of which is the user's
: company name. I dynamically build a drop down for this field on the search
: page by pulling all distinct company names from the db. Of course, there
are
: several different variations of the company name in the dropdown, which
: makes it very cumbersome.
:
: Has anyone had to deal with this? If so, how did you deal with it? And/or
: does someone have an idea on how to go about dealing with it?
:
:
: Erika
: (with a *K*)
:
:
:
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
