I'm new to ASP, and am trying to code a search engine using Indexing Server (Win2k ver.).
I've been reasonably successful, but have a couple of problems:
1. DAMNED NOISE WORDS!
I get the old "The query contained only ignored words." error every now and then. What is the best way around this? Can you / should you filter out noise words from user inputted text, and if so, how?
2. UNEXPECTED SEARCH RESULTS
The code I'm using for matching an exact string is:
SELECT DocTitle, VPath, Path, Filename, Rank FROM SCOPE('DEEP TRAVERSAL OF "c:\inetpub\wwwroot\"') WHERE ((CONTAINS('"my string"')) AND ((Path NOT LIKE '%\_vti%') AND (Path NOT LIKE '%\_private%') AND (Filename NOT LIKE 'search.asp'))) ORDER BY Rank DESC
However, I get results returned with just the word string in the document, not the exact phrase. Where am I going wrong?
Any help anyone could provide would be VERY much appreciated.
Cheers guys.
how bout trying this first:
1) user "SELECT * FROM SCOPE WHERE VARIABLE ='<String type>'"
2) then use a filter
ObjRS.Filter="<what you dont want>"
this makes the SQL statment easiler to debug and u can check which syntax/part is giving u those logical errors...