I'm wondering if you could use the 'Sounds Like' SQL
(can't remember the EXACT term) function to parse input
on the company name and then replace it with the proper
spelling as it is inserted into the table.
SELECT Company
FROM Table
WHERE #Form.Company# SoundsLike Table.Company
Not sure exa
I believe you can, but wouldn't it make sense to have it create the
collection with more than just the name, say maybe the address as well? I
know that people are supposed to know everything about the company they
work for, but when they start either spelling it wrong, or put in different
name
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 namesessentially you're needing
Well, if you're going to do that, why not use Verity to create a collection
of all the company namesessentially 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 Wa
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,
We end up having someone standardize the names in house.
---
Daniel Dewey|"According to the rule of averages, if you
Systems Developer | stand with one foot in a bucket of ice,
MCP (NT srvr/wkstn/eprise) | and the other in a bed of hot coals, you
[EMAIL PROTECTED]
Erika,
Download a copy of CommerceBlocks Explorer from
http://www.CommerceBlocks.com, and use the DatabaseBlocks module to generate
code for two related tables, like the ones you're mentioning. Then take a
look at the way we do a "Filtered Select Menu," which enables you to filter
on the names o