Verity question

[calista]

This must be the day for Verity questions! I have two Verity collections, Messages and Documents. Messages is updated when a user posts a message on my discussion board. I indexed the Document directory manually through the CF Administrator to create and index the Documents collection. However, when I run a search on the Documents collection, it returns data from the Messages collection as well. Why is this happening?

Here is my search:
<CFSEARCH COLLECTION=&quot;Documents&quot;
NAME=&quot;GetSearchInfo&quot;
TYPE=&quot;SIMPLE&quot;
CRITERIA=&quot;#SearchTerm#&quot;> Calista :-X
Jedi Knight,
Champion of the Force

 

[tleish]

A few troubleshooting items I would check would be to make sure that the 2 collections do not share the same directory.

Also, it could be that the <cfindex> code is somehow indexing the wrong items, or additional items (ie Documents could be indexing pages for doucments and messages). Double check the indexing code for both collections. - tleish

 

[calista]

The collections are in different folders in the same directory.

This is the message indexing, where I actually index the results of a query.
<CFQUERY NAME=&quot;IndexMessages&quot;
DATASOURCE=&quot;#Application.Datasource#&quot;
DBTYPE=&quot;ODBC&quot;>
SELECT MessageID,
MsgAuthor,
MsgMessage
FROM MessageTable
</CFQUERY>
<CFINDEX
ACTION=&quot;Update&quot;
COLLECTION=&quot;Messages&quot;
QUERY=&quot;IndexMessages&quot;
KEY=&quot;MessageID&quot;
TITLE=&quot;MsgMessage&quot;
TYPE=&quot;Custom&quot;
CUSTOM1=&quot;MsgAuthor&quot;
BODY=&quot;MsgMessage&quot;>

I indexed the Document collection through the Administrator, not with a program. Calista :-X
Jedi Knight,
Champion of the Force

 

[tleish]

Have you purged the Documents collection lately? - tleish

 

[calista]

Yes, in fact I purge the collection before I index it. Calista :-X
Jedi Knight,
Champion of the Force

 

[calista]

I finally seem to have solved the problem by the brute force method. I deleted both collections, then recreated them and indexed them. I completed the Documents collection before doing the Messages collection. Calista :-X
Jedi Knight,
Champion of the Force