Verity trouble

[calista]

Well, I THOUGHT I had this solved! I'm still having a problem with indexing my two collections. When I conduct a search against one collection (Documents), I get results from the other one (Messages), as well. I am assuming the problem is in the indexing process, but I'm certainly open to suggestion. Where do I start looking for answers?

Thanks! Calista :-X
Jedi Knight,
Champion of the Force

 

[mikeshort]

I would start by purging both collections and indexing them again.

 

[calista]

Thanks, but I've done that. The only way I've been able to get this to work is to delete (not Purge, that doesn't solve the problem), re-create, and index both collections each time I add a document. (And, do the Documents collection first!)If I try to do an UPDATE, I get this problem. Needless to say, it is a pain to have to do this everytime I add a document. Calista :-X
Jedi Knight,
Champion of the Force

 

[calista]

Sorry to be a pest, but this is really driving me crazy! :-(
I would like to add that I have two search applications in two different directories. One is the message search that is part of my discussion board, and the other is on my main menu. I always call the collections by name explicitly, not using a variable. I do not SEEM to have the reverse problem (documents appearing in the message search results). Any ideas? I would really appreciate it! In case it helps anyone, here is my update code for the Documents collection:

<!--- Index the documents so new documents are searchable. --->
<CFQUERY NAME=&quot;IndexDocuments&quot;
DATASOURCE=&quot;#Application.Datasource#&quot;
DBTYPE=&quot;ODBC&quot;>
SELECT DocID,
DocTitle,
DocDescription
FROM DocumentTable
</CFQUERY>
<CFINDEX
ACTION=&quot;Update&quot;
COLLECTION=&quot;Documents&quot;
QUERY=&quot;IndexDocuments&quot;
KEY=&quot;DocID&quot;
TYPE=&quot;Custom&quot;
BODY=&quot;DocTitle, DocDescription&quot;> Calista :-X
Jedi Knight,
Champion of the Force

 

[calista]

Just in case anyone's interested, I think I finally have a answer to this. Eliminating .cfm and .cmfl extensions from the indexing operation for Documents seems to take care of it. Calista :-X
Jedi Knight,
Champion of the Force