Hey,
You can first check the fields in your Body section to ensure that all
of them are spelt correctly and are actually contained in the databatse.
Make sure your ID field is also a unique and key field in the database.
I've not used the Custom1 fields very much..try taking that out.
Next..try tremoving fields from the Body section one by one and see if
it works.
Verity isn't very cool for debugging errors within the tag itself, and
I've run into trouble myself many times :(
Use a very simple page, and a CFDUMP of a search to test your index:
<cfsearch collection="yourcollectionname"
name="myResults"
criteria="">
<cfdump var="MyResults">
-Gel
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
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>
______________________________________________________________________
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
