Hi, try using the IN keyword and pass a comma seperated list....see below.
It should work if this is what you want.
> Without using Verity what is the best way to set up a search for keywords
> That I have setup in a database. I have tried several different things and
> nothing seems to be working. I am doing a query against the database and
> everything works fine except if there is more than one keyword it only
> sees
> the first keyword. my code looks something like this:
>
> <cfif Len(Trim(keywords))>
>
> <cfquery NAME="search" DATASOURCE="search">
> SELECT ID, title, Description, hyperlink, keywords
> FROM search
> WHERE keywords LIKE '#keywords#%'
keywords IN (#PreserveSingleQuotes(myList)#)
> </cfquery>
>
> <cfelse>
>
> <h3>You didn't enter a keyword!</h3>
>
> </cfif>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
