Query Indexing Server Catalogs

[shreejarajan]

Hi Forum,

I would like to include Indexing Server in my aaplication which uses Sql 2000 for its backend processing.

I have Encountered a problem in Querring Indexing Server Catalogs.



Could anyone help me to querry indexing server catalogs for searching files having the keyword as mentioned below:

ASP(4) and JAVA(3)

i am trying to query the indexing server to find all the word documents which has text "ASP" six times and the text "JAVA" three times in it.

the following query works fine for the keyword:

ASP and Java

SELECT * FROM OPENQUERY(WEBCATALOG, 'SELECT FileName, Path, VPath

FROM SCOPE(''DEEP TRAVERSAL OF("/Info")'')

WHERE CONTAINS(FileName,''asp and java'') ')

Could anyone help me to solve this problem of specifying the no of hits of each keyword in the query.


Thanks in Advance

Shreeja