Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Code Support: ASP (Non-Forum Related)
 MS Index Server Queries
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

TerryG
Junior Member

United Kingdom
179 Posts

Posted - 03 April 2002 :  12:49:53  Show Profile
When I query Index server with something like "bottle OR if" it correctly gives me all the pages containing 'bottle' and none containing 'if' as I have it specified as a noise word.
However if I query using 'bottle AND if' I get error code 80041605 "The query contained only ignored words" Any one know why it seems to treat all words as noise words in a 'AND' query containing one or more noise words? The relevant bits of my code are as follows:

<%
Set rsSearch = Server.CreateObject("ADODB.Recordset")
strConn = "Provider=MSIDXS; Data Source=Web"
strSearchFor = Replace(Trim(Request.Form("txtSearchFor")),"'","''")
SELECT CASE strSearchType
CASE "All"
strSearchFor = Replace(strSearchFor," "," AND ")
CASE "Any"
strSearchFor = Replace(strSearchFor," "," OR ")
END SELECT

' construct the search string
strSearch = "SELECT DocTitle, vPath, FileName, Characterization, Size" & _
" FROM SCOPE()" & _
" WHERE CONTAINS ('" & strSearchFor & "')"



  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.25 seconds. Powered By: Snitz Forums 2000 Version 3.4.07