If someone searched multiple key words like "Baseball football soccer" And you are searching on 'Baseball football soccer%' The whole string 'baseball football soccer' would Have to appear the % only implies that any records with Baseball football soccer AND THEN SOME, would appear. Take Dougs suggestion and use <CFCOLLECTION>
-----Original Message----- From: Steven Lancaster [mailto:[EMAIL PROTECTED]] Sent: Friday, November 02, 2001 11:09 AM To: CF-Talk Subject: Newbie question I new to this list and new to CF. I have a question though. I have a very small search engine I am trying to create. I am using CF 5 and I am using Access as the database. I can get it to find the entries, but it only sees the first keyword and nothing after that. Here is my code see if you can help me PLEASE! I also need to be able to shoot an error if they enter a keyword that is not listed. I am completely lost about what I am doing wrong. <CFQUERY NAME="search" DATASOURCE="search"> SELECT ID, title, Description, hyperlink, keywords FROM search WHERE keywords = keywords <cfif keywords IS NOT ""> AND keywords LIKE '#keywords#%' <CFELSE> <h3>You did not enter a keyword!!</h3> </cfif> </CFQUERY> <html> <head> <title>Untitled</title> </head> <body> <cfoutput query="search"> <strong>#search.RecordCount# Results</strong><br><br><br> <table cellspacing="2" cellpadding="2" border="0"> <tr> <td></td> </tr> <tr> <td>#title#</td> </tr> <tr> <td>#Description#</td> </tr> <tr> <td><a href="#hyperlink#">Test</a></td> </tr> </table> </cfoutput> Steven Lancaster WebMaster Core Laboratories 6316 Windfern Houston, TX 77040 mailto:[EMAIL PROTECTED] http://www.corelab.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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
