<!--- Convert to Comma List ---> <cfset search_value = "red red, blue, green, brown red green blue brown"> <cfset search_value = reReplace(search_value, "\W+", ",", "all")>
<!--- In Your Query ---> column_name IN (<cfqueryparam value="#lcv#" cfsqltype="cf_sql_varchar" list="true">) On Tue, Feb 26, 2008 at 11:38 AM, Raymond Camden <[EMAIL PROTECTED]> wrote: > You can treat the search as a list w/ 2 delimiters (, and " "). This > then gives you a nice list. > > I'm not sure how you want to handle OR versus AND. If you have another > form field "Match All or Match Any" then you can check that, and > simply loop over your list and use either an AND or an OR. > > > On Tue, Feb 26, 2008 at 10:34 AM, Les Mizzell <[EMAIL PROTECTED]> > wrote: > > I'm wanting to modify a site search (field in SQL Server database) so > > that in a single input field, a user could enter: > > > > 1. red > > 2. red, blue, green, brown > > 3. red green blue brown > > > > .... and in return, get all results that contained one/some/all of the > > entered terms. > > > > In theory, what would be the best way to go about this? > > > > There was a previous thread on this, but so far, I've been unable to > > find it. Anybody got the URL of the original thread? > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:299898 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
