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
Wow. Five copies of my message made it to the list. Apologies to all.
Keith
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives:
We had a similar issue with the City field in a database. We maintain a
City table, and each user record only contains the primary key (an integer
id) to the corresponding record in the City table. For the user interface
we created a combo-type box, so that a user could either select their City
Unless you've got a table of distinct companies for registrants to choose
from, you've got to solve the problem in the search application. Using a
drop down list here, when you know there could be multiple spellings of a
company, is probably the wrong approach. It depends a little on how exact
17:26
To: CF-Talk
Subject: RE: Data Integrity - Q of the Day
We had a similar issue with the City field in a database. We maintain a
City table, and each user record only contains the primary key (an integer
id) to the corresponding record in the City table. For the user interface
we created
5 matches
Mail list logo
