November 18th, 2002, 02:45 PM
|
|
Disgruntled Netscape User
|
|
Join Date: Jun 2001
Location: Whangarei, New Zealand
Posts: 81
Time spent in forums: 1 h 27 m 24 sec
Reputation Power: 7
|
|
|
Index Server Search Query
Hey guys,
I'm having trouble getting my head around the query language for an Index Server Search w/ASP.
I have some dummy content pages that have text like "this file contains things" and "this file contains stuff".
I've tried these two queries:
PHP Code:
SELECT DocTitle, VPath, Path, Filename, Rank FROM SCOPE('DEEP TRAVERSAL OF "c:\inetpub\wwwroot\"')
WHERE ((CONTAINS(' "file contains" ') >0)
AND ((Path NOT LIKE '%\_vti%') AND (Path NOT LIKE '%\_private%') AND (Filename NOT LIKE 'search.asp')))
ORDER BY Rank DESC
And:
PHP Code:
SELECT DocTitle, VPath, Path, Filename, Rank FROM SCOPE('DEEP TRAVERSAL OF "c:\inetpub\wwwroot\"')
WHERE ((CONTAINS(' "file" AND "contains" ') >0)
AND ((Path NOT LIKE '%\_vti%') AND (Path NOT LIKE '%\_private%') AND (Filename NOT LIKE 'search.asp')))
ORDER BY Rank DESC
With neither returning results.
If I query just "file" or "fil*" I get matches fine.
Also, if I query "*ile" I get no matches.
Any idea where I'm going wrong? Any help would be very much appreciated.
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
