You will need to put back in the leading % in case the word they are searching for is in the middle of a title.
Example Search string = "Time" Will return = "Time to go" Will not return = "It's Time to go." Also someone else mentioned using upper(), on the column and the search string your looking for to get by the case sensitivity of the db, I would recommend you doing it as well. Tim -----Original Message----- From: Mike Miessen [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 26, 2002 1:15 PM To: CF-Talk Subject: RE: New User I took out the leading % and I dropped the ?TITLE from the action on the process button and my query now works. Thanks to you guys :) -----Original Message----- From: Clint Tredway [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 26, 2002 12:07 PM To: CF-Talk Subject: Re: New User Take out the leading % and your query will work. With both % in there this returns everything because to SQL, your string is like everything in the database. HTH, Clint ----- Original Message ----- From: "Mike Miessen" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Thursday, December 26, 2002 11:03 AM Subject: New User > I have been trying to do a search of a database. It is a very small > testing database and I wrote a search entry form with dream weaver with > one field. This field should search on the title field of the database > and return results that contain the entry. I am a raw newbie here and > contemplating beating my head against a wall on this. Well my query > does not seem to work. I get all the records returned every time not > just the ones that contain the search term. > > Here I was thinking this would be easy. Boy was I wrong! Here is my > code Can anyone tell me what I'm doing wrong? The path to the search > form is > > http://bluegrasspro.net/bluegrasspro/datasources/eventquery.cfm > > > > <cfquery name="rsTitle" datasource="bluegrasspro" username="LOL" > password="YeaRight" debug="yes"> > <cfparam name="TITLE" default="null"> > SELECT * FROM bluegrasscalendar WHERE Title LIKE '%#TITLE#%' > </cfquery> > > <html> > <head> > <title>Query Results</title> > <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> > </head> > > <body> > <cfoutput query="rsTitle"> > #rsTitle.Title#<br> > </cfoutput> > > </body> > </html> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq 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
