Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

INDEX SERVER SEARCH ON MULTI DOC TYPES

Posted on 2003-11-14
1
Medium Priority
?
208 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 1

Accepted Solution

by:
subtext101 earned 450 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

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Question has a verified solution.

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

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…
Have you ever needed to get an ASP script to wait for a while? I have, just to let something else happen. Or in my case, to allow other stuff to happen while I was murdering my MySQL database with an update. The Original Issue This was written…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…

609 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