I think it is your submit page form tag. <form name="EventTitleSearch" method="post" action="TitleSearchResults.cfm?TITLE" >
you are going to end up with two "Title" variables on the results page, one passed by the url line and one by the form. Cold Fusion has to pick one of these two to default to, and it is going to default to the url version (always). So you can do a couple of things: 1. remove the ?title in the form action parameter. 2. specify the scope of the title variable in the results page <cfparam name="form.TITLE" default="null"> <cfquery name="rsTitle" datasource="bluegrasspro" username="LOL" password="YeaRight" debug="yes"> SELECT * FROM bluegrasscalendar WHERE Title LIKE '%#form.TITLE#%' </cfquery> And I would move the cfparam out of the cfquery and place it one line above it. HTH Jerry Johnson >>> [EMAIL PROTECTED] 12/26/02 12:03PM >>> 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 Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm

