hspc
October 17th, 2004, 03:22 AM
Hi
I use SQL Server 2000 + MS search service to add a text search capability to an application.
I use CONTAINS keyword to search and the problem that SQL server raises an error (Execution of a full-text operation failed. A clause of the query contained only ignored words.) When the words entered by user contain noise words like (And-or-also-an-another).
How to make the engine ignores the noise words?
OR:
How to get a complete list of keywords and noise words at runtime to filter them?
Notes:
-noise.dat file does not contain all the invalid characters.
-I can't use FREETEXT instead of CONTAINS because It gets awful result with Arabic language (the major language used in the project)
any comments / suggestions are appreciated and welcomed.
I use SQL Server 2000 + MS search service to add a text search capability to an application.
I use CONTAINS keyword to search and the problem that SQL server raises an error (Execution of a full-text operation failed. A clause of the query contained only ignored words.) When the words entered by user contain noise words like (And-or-also-an-another).
How to make the engine ignores the noise words?
OR:
How to get a complete list of keywords and noise words at runtime to filter them?
Notes:
-noise.dat file does not contain all the invalid characters.
-I can't use FREETEXT instead of CONTAINS because It gets awful result with Arabic language (the major language used in the project)
any comments / suggestions are appreciated and welcomed.