I may be wrong on this but I don't think you can put <cfparam
name="TITLE" default="null"> in the <cfquery> tag pairs.
Try this
<cfparam name="TITLE" default="null">
<cfquery name="rsTitle" datasource="bluegrasspro" username="LOL"
password="YeaRight" debug="yes">
SELECT *
FROM bluegrasscalendar
WHERE Title LIKE '%#TITLE#%'
</cfquery>
Hope this works.
-AD
-----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
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.