I'm creating a search feature (for this site actually) so users can search through past discussions. If I search for a word such as "more" I get...

How It Works

Get an answer in three easy steps. Here's how it works...

Ask Your Question

1. Ask Your Question

Enter your programming question at the top of this page and click Get An Answer.

Pick Your Priority

2. Pick Your Priority

Tell us how quickly you want your programming question answered.

Get An Answer

3. Get An Answer

Connect with your programmer via online chat or telephone call.

Get An Answer 

Answer

Customer
I'm creating a search feature (for this site actually) so users can search through past discussions. If I search for a word such as "more" I get this error message: Server: Msg 7619, Level 16, State 1, Line 1 The query contained only ignored words. Does anyone know where I can get a list of these "ignored" words? Thanks in advance! Regards, Matthew Pomar
Posted
jerasi
Programmer
I had to create a full text catalog and had the same problem, I found the file in the SQL directory (on the server) it is named noise.txt and made of a list of words that are separeted by a CR you can add or remove words from that list but, it is not recomended (what if a user enters 'a' as a search term) What i did is put error handeling around the query and if i got the error code for 'only noise words' then i executed another query (which is the default query for the page). I hope this helps.
Posted
Matthew Pomar
Customer Support
Ahh, thanks for the fast response. What do you mean when you executed the default query? - Matt
Posted
jerasi
Programmer
I can see that you're programming with ASP I had to do it with ColdFusion so i cant really tell you how it works, but the way i did it is I put error handeling around my Full text query and if there was an error i executed another query with the same name as my full text query. The second query is the same as the default query i execute to load the page at the first place (say all records that are newer then 1 week) p.s. your forum's layout is one of the better ones i saw so far :)
Posted
Matthew Pomar
Customer Support
Thanks for the compliment on the forum. I searched for noise.txt but didn't find it. I did find noise.dat and it matches your description. I'll play around with that and see if I can come up with a better list for this site. Obviously someone might want to search for words such as "between, each, do, for, from, and get" at a developer forum. Thanks again for your quick response. Regards, Matthew Pomar
Posted
Get An Answer 

quoteTestimonialsquote

About ExpertHelp

ExpertHelp is changing the way you connect with service professionals.

Whether you have a quick question while preparing your taxes, troubleshooting a computer problem, or need to hire an attorney, ExpertHelp is the most convenient and affordable way to connect with the right service professional to get the job done.

ExpertHelp has been in business since 2011, is an A+ Rated Better Business Bureau accredited member, and offers a 100% satisfaction guarantee on every question you ask!

Get An Answer 

More Programming Questions...

Date
Questions

9/20/2019
how do I get a script to run on boot every time with Linux? (Need...

12/27/2018
I have an excel database that is updated daily, with corresponding...

3/9/2016
****NOTE: CANNOT BE TOO COMPLICATED, NOTHING MORE ADVANCED THAN FOR...

10/6/2013
Looking for assistance with redirecting categories and...

5/6/2013
How can I receive online programming help for win8app

Ask Your Programming Question & Get An Answer Now!