ASP / IIS Search

Hey guys,

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...