Try using one of the following in your query statements:
1.
Where tableField1 = '#form.variable#'
2.
Where tableField1 LIKE '#form.variable#%'
The % is a "wild card" so bu would return anything that started with bu, ie
bulb, bulbous but not xbulb
3.
Get one of Uncle Ben's (or someone's) books ;-)
or
http://www.thenetprofits.co.uk/coldfusion/faq/#answer82
HTH
Stephen
-----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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists