If there is no value in the TITLE variable you will get the behavior you're
seeing.
1. Scope your variable. Form.Title instead of Title.
2. Trap for no value.
<cfif IsDefined("Form.Title") AND Len(Trim(Form.Title)) GT 0>
<cfquery ...>
...
</cfif>
3. SQL is case-sensitive. If you want case-insensitivity do something like
this in your WHERE clause:
UPPER(Title) LIKE '%#UCase(Form.TITLE)#%'
> -----Original Message-----
> From: Mike Miessen [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, December 26, 2002 12:04 PM
> 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.
