ghostdogenterprise
Programmer
Having an odd problem. Hoping I can get a little help. I've created a Verity collection using the CF admin and I've set up an index and search pages to pull the data from a database.
Here's the problem: When I submit a search word or Article number to the collection I get 0 results regardless. I look at my database and I know that I have records put I'm still getting no results and not errors. I'm thinking it's either the logic I employ on the beginning of the action page or a problem with my connection to the collection or database. Any help Would be appreciated.
Indexdata Page
<cfquery name="GetResults" datasource="OPARAS">
SELECT ID, Upload, Description, Subject, Date_Modified,
Date_Created, Keywords, Notes
From Reference
</cfquery>
<cfindex action="update"
collection="OPARAS"
key="ID"
Type="Custom"
Title="Subject"
Query="GetResults"
Body="Description, Keywords, ID, Upload, Subject, Category, Subject, Notes"
Custom1="ID">
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Indexing Complete</title>
</head>
<body>
<h1>Indexing Complete</h1>
</body>
</html>
CF SEARCH PAGE
<table width = 100% border="0">
<tr>
<td align="left"><br></td>
<td valign="top" align="left">Search Factbook <nobr>
<form
action="adminaction.cfm"
method="post"
name="Search"
target="search"
style="adminbox"
ONSUBMIT="setTimeout('document.Search.reset()', 500) ;">
<p>Keywords:
<input type="Text" name="Criteria">
<br>
Article Number:
<input type="text" name="ID">
<input type="submit" value="Search" name="Search">
<input type="Reset" value="Reset" name="Reset">
<br>
</p>
</form></td><td valign="top" align="right"><a href="refau1.cfm" target="_parent">Add New Entry</a></td>
CF Action Page
<cfif Form.ID is not "">
<!-- If an Article_ID is Given, Use it and ignore other input -->
<cfset TheCriteria = "CF_Custom1 <MATCHES> #Form.ID#">
<cfelse>
<!-- Only Keywords are Specified -->
<cfset THECriteria = "#Form.Criteria#">
</cfif>
<cfsearch collection="OPARAS"
Name="GetResults"
Criteria="#THECriteria#">
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Search Results</title>
<!-- <link rel="stylesheet" href="adminstyle.css"> -->
</head>
<body>
<table align="center" width="50%"><h4><cfoutput>Retrieved #GetResults.RecordCount# files </cfoutput></h4>
<p align="right"><cfoutput>Actual Criteria Used: #HTMLEditFormat(THECriteria)#</cfoutput></p>
<dl>
<cfoutput query="GetResults">
<!--- <tr bgcolor="#IIf(CurrentRow Mod 2, DE('ffffcc'), DE('eeeeee'))#"> --->
<td> <dt><i>#NumberFormat(Round(Score * 100))#%</i>
<a href="refau1.cfm?ID=#Custom1#">#Title#</a></td></tr>
<tr></tr><td><dd><font size="-1"><i><b>Article Number #Custom1#. </b></i>#Summary#</font></td></tr>
</cfoutput>
</dl></table>
</body>
</html>
Here's the problem: When I submit a search word or Article number to the collection I get 0 results regardless. I look at my database and I know that I have records put I'm still getting no results and not errors. I'm thinking it's either the logic I employ on the beginning of the action page or a problem with my connection to the collection or database. Any help Would be appreciated.
Indexdata Page
<cfquery name="GetResults" datasource="OPARAS">
SELECT ID, Upload, Description, Subject, Date_Modified,
Date_Created, Keywords, Notes
From Reference
</cfquery>
<cfindex action="update"
collection="OPARAS"
key="ID"
Type="Custom"
Title="Subject"
Query="GetResults"
Body="Description, Keywords, ID, Upload, Subject, Category, Subject, Notes"
Custom1="ID">
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Indexing Complete</title>
</head>
<body>
<h1>Indexing Complete</h1>
</body>
</html>
CF SEARCH PAGE
<table width = 100% border="0">
<tr>
<td align="left"><br></td>
<td valign="top" align="left">Search Factbook <nobr>
<form
action="adminaction.cfm"
method="post"
name="Search"
target="search"
style="adminbox"
ONSUBMIT="setTimeout('document.Search.reset()', 500) ;">
<p>Keywords:
<input type="Text" name="Criteria">
<br>
Article Number:
<input type="text" name="ID">
<input type="submit" value="Search" name="Search">
<input type="Reset" value="Reset" name="Reset">
<br>
</p>
</form></td><td valign="top" align="right"><a href="refau1.cfm" target="_parent">Add New Entry</a></td>
CF Action Page
<cfif Form.ID is not "">
<!-- If an Article_ID is Given, Use it and ignore other input -->
<cfset TheCriteria = "CF_Custom1 <MATCHES> #Form.ID#">
<cfelse>
<!-- Only Keywords are Specified -->
<cfset THECriteria = "#Form.Criteria#">
</cfif>
<cfsearch collection="OPARAS"
Name="GetResults"
Criteria="#THECriteria#">
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Search Results</title>
<!-- <link rel="stylesheet" href="adminstyle.css"> -->
</head>
<body>
<table align="center" width="50%"><h4><cfoutput>Retrieved #GetResults.RecordCount# files </cfoutput></h4>
<p align="right"><cfoutput>Actual Criteria Used: #HTMLEditFormat(THECriteria)#</cfoutput></p>
<dl>
<cfoutput query="GetResults">
<!--- <tr bgcolor="#IIf(CurrentRow Mod 2, DE('ffffcc'), DE('eeeeee'))#"> --->
<td> <dt><i>#NumberFormat(Round(Score * 100))#%</i>
<a href="refau1.cfm?ID=#Custom1#">#Title#</a></td></tr>
<tr></tr><td><dd><font size="-1"><i><b>Article Number #Custom1#. </b></i>#Summary#</font></td></tr>
</cfoutput>
</dl></table>
</body>
</html>