On your submission form, you have "TitleSearchResults.cfm?TITLE". Take out the "?Title" and it works fine.
--> -----Original Message----- --> From: Mike Miessen [mailto:[EMAIL PROTECTED]] --> Sent: Thursday, December 26, 2002 9:04 AM --> To: CF-Talk --> 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm
