Search finds 2 records, only displays 1 (URGENT)

rmz8 · Sep 20, 2000

I am using Verity to search database fields. I've used record count to find out how many records were found during the search. It says 2 when I enter the key word 'stock options' (with out the quotes), but only one record appears.

To see what I'm talking about, enter 'stock options' (without the quotes) into the text box at the site below.

http://www.myjobcoach.com/search_result.html

Here is CFML for my search page:

================================

<html>
<head>
<CFQUERY NAME="Search" DATASOURCE="myjobcoach" BLOCKFACTOR="100">SELECT * FROM Content_Database WHERE Show LIKE '%Yes%'</CFQUERY>
<CFQUERY NAME="Design" DATASOURCE="myjobcoach" BLOCKFACTOR="100">SELECT Client_Name, Title, Font, Body_Attribute1, Body_Attribute2, Body_Attribute3, Body_Attribute4, Header, SearchResults_Body, Footer FROM Site_Structure WHERE Client_Name LIKE '%#Form.Client_Name#%'</CFQUERY>
<CFINDEX ACTION="REFRESH" COLLECTION="Search" KEY="ID" type="CUSTOM" TITLE="Headline" QUERY="Search" BODY="Body" LANGUAGE="English">
<CFSEARCH NAME="SearchDB" COLLECTION="Search" TYPE="Simple" CRITERIA="#Form.Keywords#" LANGUAGE="English">
<title></title>
</head>

<CFOUTPUT QUERY="Design"><body bgcolor="#Body_Attribute1#" link="#Body_Attribute2#" alink="#Body_Attribute3# vlink="#Body_Attribute4#">

#Header#
<div align="center">Your search for "#Form.Keywords#" returned #SearchDB.RecordCount# result(s)</div> 
<CFIF SearchDB.RecordCount EQ "0">
There are no articles to display. 
<CFELSE>
<a href="display_article.cfm?ID=#SearchDB.Key#&Client_Name=#Design.Client_Name#">#SearchDB.Title#</a> #SearchDB.Summary#
</CFIF> 
#Footer#
</body></CFOUTPUT>
</html>

================================
[sig]Ryan ;-] [/sig]

Guest_imported · Sep 21, 2000

I am afraid my test of your search box didn't fair well.
(timed out)

If the data in the database is relatively "static", or gets updated by another process (ie; a spider), The verity collection should only be updated then.

Possible refreshing your collection on every "search" is causing the timeout?

It may be better to seperate the "updating" of the verity collection from the search page. I have a little script I run at the end of the day that "purges" and rebuilds the collections because I post a lot of data to cfhub.com every day, both web pages and database content. If you have a "stock grabber", have it update your collection after it updates the database.

I will check back (maybe the server is way swamped?)

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Search finds 2 records, only displays 1 (URGENT)

rmz8

Programmer

Guest_imported

New member

Similar threads

Part and Inventory Search

Sponsor