Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-03-10 : 09:18:26
|
Chris writes "Is there a way of programatically referencing the stop words file when using a SQL Server 7.0 full text index?
I am writing a straightforward search engine and want to identify to a user running a search that they have entered a stop word and that their query will not include this word. The only ways I can see to do this are:
1) using the file system object to open the stop words file, and reading the contents of the file into a recordset(?) object. I would have to pass in the file path to the noise words file, which limits reusability.
2) sticking the contents of the noise words into a db table, and querying this each time the search runs. Again, this restricts reusability and adds an adminstrative overhead.
3) getting more silly: searching individually for each word in the query, testing for an error, removing from the query string if there is an error, etc...
Any ideas?
Chris
(PS The platform is NT4.0 SQL Server 7.0.)" |
|
|
|
|
|
Dynamically identifying stop words in full text indexes