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#%'
</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
