From: Claremont, Timothy
Date: Tue, 28 Sep 2004 11:46:52 -0400
> If the end user just enters "e" in the search box, I am not so sure that
> I want every name that contains an 'e' to be returned.... Or do I???
Typically, I expect searches like that to have at least the first
letter in there, so I only do wildcards at the end of the string.
For example:
WHERE firstname like '#searchString#%'
(of course, you'd use <cfqueryparam> for this :) )
I've only had one app where the clients wanted a full wildcard search
('%#searchstring#%'), but they changed their minds after seeing it in
action (apparently they didn't believe me when I said it could return
far too many results).
Scott
--
-----------------------------------------
Scott Brady
http://www.scottbrady.net/
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
