Hey! This is a different idea! .......
What does anyone else thing of this? Using Verity as a solution to searching
for a particular company? Can I set up verity to index just one field in one
database?
Erika
(with a *K*)
-----------------------------------------------------
-----Original Message-----
From: Judith Taylor [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 10, 2001 8:25 PM
To: CF-Community
Subject: Re: Data Integrity - Q of the Day
Well, if you're going to do that, why not use Verity to create a collection
of all the company names....essentially you're needing to search your
database for all existing variations of a company name and using Verity
reduces the load/hit to your DB.
Just a thought.
The Other Judith
Daryl Walsh put into words:
>possibly an initial, smaller form in which the user enters what they think
>their company is (e.g., 'Lilly', 'Eli Lilly', etc). they then click submit
>and
>you run a search using LIKE and OR's in your WHERE clause on each
discrete
>word
>to see if you already have that company in your db and, if so, the
spelling.
>bring that data back to the user to populate a drop down on the main form
or
>even as a list with checkboxes
>on another initial page (where they would confirm/select their company
>name). and then
>be taken to the main form with their company name pre-populated.
Judith Taylor
ICQ: 67460562
Freelance ColdFusion Developer - Athens, OH
Friends don't let friends code before coffee.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-community@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists