Try this, sloppy code but hope it helps:
Jason Larson
[EMAIL PROTECTED]
<html>
<head>
<title>Untitled</title>
</head>
<body>
<cfif Form.Keyword NEQ "">
<CFQUERY NAME="search" DATASOURCE="search">
SELECT ID, title, Description, hyperlink, keywords
FROM search
WHERE keywords LIKE '%#Form.Keywords#%'
</CFQUERY>
<cfset TotalRecords = Search.RecordCount>
<cfelse>
<h3>You did not enter a keyword!!</h3>
</cfif>
<cfif isdefined("TotalRecords") AND TotalRecords NEQ 0>
<strong>#TotalRecords# Results</strong><br><br><br>
<table cellspacing="2" cellpadding="2" border="0">
<cfoutput query="search">
<tr>
<td></td>
</tr>
<tr>
<td>#title#</td>
</tr>
<tr>
<td>#Description#</td>
</tr>
<tr>
<td><a href="#hyperlink#">Test</a></td>
</tr>
</cfoutput>
</table>
</cfif>
</body>
</html>
-----Original Message-----
From: Steven Lancaster [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 02, 2001 9:09 AM
To: CF-Talk
Subject: Newbie question
I new to this list and new to CF. I have a question though. I have a
very small search engine I am trying to create. I am using CF 5 and I am
using Access as the database. I can get it to find the entries, but it
only sees the first keyword and nothing after that. Here is my code see
if you can help me PLEASE! I also need to be able to shoot an error if
they enter a keyword that is not listed. I am completely lost about what
I am doing wrong.
<CFQUERY NAME="search" DATASOURCE="search">
SELECT ID, title, Description, hyperlink, keywords
FROM search
WHERE keywords = keywords
<cfif keywords IS NOT "">
AND keywords LIKE '#keywords#%'
<CFELSE>
<h3>You did not enter a keyword!!</h3>
</cfif>
</CFQUERY>
<html>
<head>
<title>Untitled</title>
</head>
<body>
<cfoutput query="search">
<strong>#search.RecordCount# Results</strong><br><br><br>
<table cellspacing="2" cellpadding="2" border="0">
<tr>
<td></td>
</tr>
<tr>
<td>#title#</td>
</tr>
<tr>
<td>#Description#</td>
</tr>
<tr>
<td><a href="#hyperlink#">Test</a></td>
</tr>
</table>
</cfoutput>
</body>
</html>
Steven Lancaster
WebMaster
Core Laboratories
6316 Windfern
Houston, TX 77040
mailto:[EMAIL PROTECTED]
http://www.corelab.com
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
