Solved

INDEX SERVER SEARCH ON MULTI DOC TYPES

Posted on 2003-11-14
1
202 Views
Last Modified: 2012-06-27
I need to create an index search for a site that will return everything in the site directory.

This means indexing all types of documents and all asp and htm(l) files (i'll also need to access data in a SQL DB but can handle this on a separate search if not possible with index searching.)

I have created a search for a specific folder containing ONLY .pdf docs that works OK but need advice on how to extend this to the rest of the site.
0
Comment
Question by:jfriel
1 Comment
 
LVL 1

Accepted Solution

by:
subtext101 earned 150 total points
ID: 9749011
If you're using ADO to do the query, then the answer will be in the select statement, which might be along the lines of:

SELECT DocTitle,Filename,VPath,Rank,Characterization,Write FROM SCOPE()
WHERE CONTAINS(Contents, 'SomeKeyword AND SomeOtherKeyword')
ORDER BY RANK DESC

The key thing's "Scope()" which should give you results from the whole catalogue.  In the Index Server MMC, you want to make sure that the catalog is set to track files from a specified virtual server, rather than explicitly adding a directory.  You may also want to check the boxes that say something like Index Files with Unknown Extensions.

In practice, you don't really want every file - especially if there are frontpage extensions on the website.  You can be more specific with the query, e.g.

SELECT DocTitle,Filename,VPath,Rank,Characterization,Write
FROM SCOPE('"D:\Somefolder\Webfolder"') WHERE
NOT CONTAINS(VPath, '"_vti" OR ".xml"') AND
(CONTAINS (Contents, 'SomeKeyword AND SomeOtherKeyword') OR " & _
CONTAINS (DocKeywords, 'Contents, 'SomeKeyword AND SomeOtherKeyword') OR      
CONTAINS (DocSubject, 'SomeKeyword AND SomeOtherKeyword') OR        
CONTAINS (DocTitle, 'SomeKeyword AND SomeOtherKeyword'))
ORDER BY RANK DESC

If a catalog's not returning the correct results then it more often than not seems to be the catalog configuration which is screwy.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Displaying number of records depdning on table contents - classic asp 13 45
Need help editing script 3 79
Question about ASP Including Files 6 61
IP API - need data... 4 27
I recently decide that I needed a way to make my pages scream on the net.   While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one…
I would like to start this tip/trick by saying Thank You, to all who said that this could not be done, as it forced me to make sure that it could be accomplished. :) To start, I want to make sure everyone understands the importance of utilizing p…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question