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:299895 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
