"Query Contains Only Ignored Words" (#7619) 
Author Message
 "Query Contains Only Ignored Words" (#7619)

Quote:
> I am having a problem when querying data from database.
> Some of the queries throw an exception and I don't know how to fix it.

> The error I get is "Query Contains Only Ignored Words" (#7619)

> Any help would be appreciated

--
Dino Buljubasic
Software Developer
http://www.***.com/


Tue, 20 Dec 2005 23:30:55 GMT
 "Query Contains Only Ignored Words" (#7619)

There is a list of words that sql server ignores when building a catalog and
can't be queries on and are called, "noise" words or ignored words. Examples
of these include "the", "and", "a", "1" etc...

You can find a list in a file called noise.* (enu in my case depends on the
language i think) and can be found in MSSQL\FTDATA\Config\

I believe this file can be edited to suit requirements but i would suggest
that removing words could result in signifcantly larger indexes and poor
performance. Though that is just my guess and haven't tried it.

Hope this helps!
R



Quote:
> > I am having a problem when querying data from database.
> > Some of the queries throw an exception and I don't know how to fix it.

> > The error I get is "Query Contains Only Ignored Words" (#7619)

> > Any help would be appreciated

> --
> Dino Buljubasic
> Software Developer
> http://rivusglobal.com



Wed, 21 Dec 2005 00:55:01 GMT
 "Query Contains Only Ignored Words" (#7619)
Dino & Rich,
Rich, you are correct, in that these files noise.* where * = language, i.e.,
noise.enu = US_English and these files can be edited with notepad.exe. Note,
the MSSearch service must be stopped to save these files. However, you must
add some client-side logic to capture the error first in the user search
string, for example see KB article 246800 (Q246800) "INF: Correctly Parsing
Quotation Marks in FTS Queries"
http://support.microsoft.com//default.aspx?scid=kb;EN-US;246800 and other
postings in this newsgroup for SearchPage.htm code examples. Also, if you're
using SQL Server 2000, see BOL title "Full-Text Search Recommendations" for
more examples and help on customizing SQL FTS.

Regards,
John


Quote:
> There is a list of words that sql server ignores when building a catalog
and
> can't be queries on and are called, "noise" words or ignored words.
Examples
> of these include "the", "and", "a", "1" etc...

> You can find a list in a file called noise.* (enu in my case depends on
the
> language i think) and can be found in MSSQL\FTDATA\Config\

> I believe this file can be edited to suit requirements but i would suggest
> that removing words could result in signifcantly larger indexes and poor
> performance. Though that is just my guess and haven't tried it.

> Hope this helps!
> R



> > > I am having a problem when querying data from database.
> > > Some of the queries throw an exception and I don't know how to fix it.

> > > The error I get is "Query Contains Only Ignored Words" (#7619)

> > > Any help would be appreciated

> > --
> > Dino Buljubasic
> > Software Developer
> > http://rivusglobal.com



Wed, 21 Dec 2005 03:42:58 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Error 7619, "The query contained only ignored words"

2. Error 7619, "The query contained only ignored words"

3. FTS query "contains"

4. The query contained only ignored words

5. Error with FTS: The query only contained ignored words

6. A clause of the query contained only ignored words

7. Query only contains ignored words

8. The query contained only ignored words.

9. Error: The query contained only ignored words

10. The query contained only ignored words.

11. The query contained only ignored words.

12. help with error The query contains only ignored words


 
Powered by phpBB® Forum Software