Sorry all - something got weird in by browser or this forum and it posted to a new thread, instead of adding.
>I can't figure this post out either (what the original post was, what >the ambiguous subject means...), but is someone looking for something >that makes SQL out of search terms? I've got a copy of a custom tag >(called boolsearch) that understands quoted phrases, NOTs, ANDs, ORs, >etc., and makes a SQL filter out of it. AFAIK, this custom tag is >generally unavailable, since I went looking for updates recently. > >LMK if that's what you (or someone) needs. > >Jamie > >On Fri, 12 Sep 2003 14:45:54 -0400, in cf-talk you wrote: > >>thanks lee...looks like a good idea....i couldn't figure out what this >>post was about...but now I see :) >> >>tony weeg >>sr. web applications architect >>navtrak, inc. >>[EMAIL PROTECTED] >>www.navtrak.net >>office 410.548.2337 >>fax 410.860.2337 >> >> >>-----Original Message----- >>From: [EMAIL PROTECTED] [EMAIL PROTECTED] >>[mailto:[EMAIL PROTECTED] >>Sent: Friday, September 12, 2003 2:22 PM >>To: CF-Talk >>Subject: Another way >> >> >>Treat the phrase/list of keywords coming in as a list: >> >><cfset keywords = " help me now"> >><!--- assign to variable (TRIM! to remove lead/trailing spaces) ---> >><cfset searchPhrase = #trim(keywords)#> >><!--- replace all space/multiple spaces with comma [delimiter] ---> >><cfset searchPhrase = #REreplaceNoCase(searchPhrase, "[ ]+", ",", >>"ALL")#> >> >><!--- use this for your query to generate the Constraints ---> >><cfloop from="1" to="#listLen(searchPhrase)#" index="counter"> >> AND columnName LIKE '%#listGetAt(searchPhrase,counter)#%' >></cfloop> >> >>This code will produce the following code: >> >>AND columnName LIKE '%help%' >>AND columnName LIKE '%me%' >>AND columnName LIKE '%now%' >> >>Use the listLen function to get number of keywords if you still need >>that. >> >>Obviously, adjust the code for "OR" instead of "AND" etc, but you get >>the idea. >> >> >>>lets say, a user enters "skateboarding atlanta half-pipe" >>>and you wanted to break that up into separate words, and know that >>>there should be 3 "...or searchTerm like '%wordHere%'" sections in a >>>query (one for each word) so that the user can search for >>>"skateboarding or atlanta or >>>half-pipe" through a sql statement. >>> >>>is this feasible, i know it has to be, just cant think past my keyboard >> >>>right now. >>> >>>thanks for any ideas.... >>> >>>....tony >>> >>>tony weeg >>>[EMAIL PROTECTED] >>>www.revolutionwebdesign.com >>>rEvOlUtIoN wEb DeSiGn >>>410.334.6331 >>> >> >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
