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 - 2000-10-16 : 18:40:48
|
David writes "I built an asp page that has a keyword search form field. The problem occurs when someone includes a noise word from the noise file. Rather than ignore the noise word, the query fails.
The query is below generates the following error ('and' is the noise word in this case:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]The query contained only ignored words.
/press/index.asp, line 132
SELECT mediaID, mediaDate, title_en AS title, subTitle_en AS subTitle FROM IRONSIDE_media WHERE articleType = 'press' AND CONTAINS(content_en, '"dogs" AND "and" AND "cats"') ORDER BY mediaDate
Any ideas? I would prefer to keep the noise file, and would rather solve this with SQL. The thought of parsing the noise file into an Applcation array and validating against it every time gives me shivers... I am using SQL 7
Thanks |
|
|
|
|
|
Noise words are causing my full-text indexed query to fail - help