To do an exact match you would just do in a query Where
something='#something#' to do a partial match you would do where something =
'#something#%' putting the % where you would like the partical match to
look, in this case anything before it would be the search criteria. So you
could put bu in and it would find bulb, bulbous and even butt, but wouldn't
find anything else unless it started with a bu first.
Bob Everland
-----Original Message-----
From: B. Wing [mailto:[EMAIL PROTECTED]]
Sent: Saturday, March 03, 2001 12:51 AM
To: CF-Talk
Subject: Advanced Database Search Form
There are two things that I'm trying to figure out how to do: an Exact
Search - if I put in a search for "bulb" it would return only "bulb" not
"bulbous".
Secondly, I've got a client who wants a search which will search only
beginning of word: For instance a search for, "bu" would return "bulbous"
but not "babudigalia".
Has anyone done either of these before? I'd appreciate any idea of where to
start to build this.
Thanks a lot!
Britta
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
