And for Oracle: http://download.oracle.com/docs/cd/B19306_01/text.102/b14218/toc.htm
http://download.oracle.com/docs/cd/B19306_01/text.102/b14217/toc.htm On Sun, Apr 13, 2008 at 4:16 AM, Scott Pinkston <[EMAIL PROTECTED]> wrote: > Look up freetext or fulltext depending on the db engine. > > MySQL: > http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html > > SQL Server: > http://msdn2.microsoft.com/en-us/library/ms176078.aspx > > > > > Hi, > > > > I'm trying to figure out how to create a dynamic search form using > > Coldfusion 8. > > > > Right now if I enter multiple words in my search field the results > > omit certain records. For example, if I put "toy blue" in the search > > field it will return results that only have "TOY BLUE" together and > > omits any records that only have "TOY" or only have "Blue" in the > > column being searched. > > > > Is there a way to add the following abilities to my basic search code > > located at the bottom of my post: > > > > - Search multiple words that are entered in the criteria input field. > > - The words can be separated by commas, spaces, or the word "and". > > - Have it so you can search multiple word phrases by using quotes. > > > > <!--- Search Form---> > > > > > > <form name="myForm" method="post" action="results.cfm"> > > > <p> > > > <input name="criteria" type="text" id="criteria"> > > > <input type="submit" name="Submit" value="Submit"> > > > </p> > > > </form> > > > > <!--- Results Page ---> > > > > <cfquery name="qSearch" datasource="myDatabase" dbtype="ODBC"> > > SELECT itemID, itemName > > > FROM myTable > > > WHERE 1 = 1 > > > > <cfif IsDefined("form.criteria") AND Len(Trim(form.criteria))> > > > and (itemName LIKE '%#form.criteria#%' or itemDescription LIKE '%#form. > > criteria#%') > > </cfif> > > > > </cfquery> > > > > <p><b>Results:</b></p> > > <cfoutput query="qSearch"> > > <p>#itemid# - #itemName#</p> > > </cfoutput> > > > > <!---------> > > > > Any help would be greatly appreciated. > > > > Thanks > > > > -C > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:303263 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4