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

Reply via email to