| Hongbo 2005-08-24, 6:10 pm |
| Hi,
I read your post at Microsoft.public.inetserver.indexserver
about "Ignore words at Catalog Level". Since you work
for Microsoft, I'd like to ask you another question regarding
the error I get.
My development server is a Windows 2000 Standard Server
with SP4 and the product server is a Windows 2003 Standard
Server. Our online store contains a Microsoft Index Server
search function. A keyword like "t-8" or "t/8" will return some
results on the Windows 2000 Server but will turn out an error
on the Windows 2003 Server. Here is the part of the error:
===
sql=SELECT filename, rank FROM scope() WHERE
CONTAINS(Content, '"t-8" and "awg" and "wire"')
ORDER BY rank desc
System.Data.OleDb.OleDbException: The query contained only ignored words.
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorhandling(Int32
hr).....
===
It seems like the Index Server in 2003 box replaces "-" and "/" automatically with
white space. This cause "t" and "8" become ignored words. But there are still
other words in the SQL statement that do not belong to the list of ignored words,
such as "awg" and "wire". I don't know why the error says : "The query contained
only ignored words."
Why does Index Server on Windows 2003 and Windows 2000 treat the same SQL
statement differently?
Would you please tell me how I can fix this?
Thank you
hb
|