473,221 Members | 2,003 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,221 software developers and data experts.

Searching for Exact Phrase - should I ignore the ignore words?

Lo all,

I was just running through some code I was writing for a site and when it
came to the 'exact phrase' search type I wasn't sure whether that should run
through and ignore the words in the ignore list or not.

I ran off and checked your ASPFAQ webby and I notice that Aaron still strips
them out, I was just wondering if this is the usual way to deal with that
search type, or whether there were good reasons when creating it to still
ignore the ignore words

My thoughts being that when giving the user an option 'exact phrase' they
may believe that every word they enter would be used etc - I seem to
remember reading something on the Google webby about Google and it saying
how it ignored the ignore words contained within the " " etc - so obviously
Google / ASPFAQ are similar in the approach - I'm not trying to re-invent
the wheel or anything it just struck me as a little odd at the time.

Anyone got any thoughts on this, ie, should I still remove the ignore words
from the search criteria on an 'exact phrase' search or not.

Thanks in advance for any help (nearly finished this now - yay!)...

Regards

Rob
Jul 19 '05 #1
6 1703
> I was just running through some code I was writing for a site and when it
came to the 'exact phrase' search type I wasn't sure whether that should run through and ignore the words in the ignore list or not.

I ran off and checked your ASPFAQ webby and I notice that Aaron still strips them out


Not anymore, you make a great point.

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
Jul 19 '05 #2
"Aaron Bertrand - MVP" wrote ...
Not anymore, you make a great point.


Seriously? So you no longer disregard the words in the ignore word array
after the submission of the search criteria for the 'exact phrase' ?

Regards

Rob
Jul 19 '05 #3
> Seriously? So you no longer disregard the words in the ignore word array
after the submission of the search criteria for the 'exact phrase' ?


Did you try it?
Jul 19 '05 #4
"Aaron Bertrand - MVP" wrote ...
Did you try it?


Funnily enough I did after I saw your post....I never feel that my
suggestions/comments here are always much use...was quite surprised when
you'd mentioned you'd changed it as I wasn't suggesting really that it
should be, only querying that that was the right way to do it for what I was
doing :o)

Regards

Rob
Jul 19 '05 #5
> I never feel that my
suggestions/comments here are always much use


Just remember that you don't have to be a guru to provide valuable feedback.

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
Jul 19 '05 #6
"Aaron Bertrand [MVP]" wrote ...
Just remember that you don't have to be a guru to provide valuable

feedback.

:o)

Cheers Aaron..

Rob
Jul 19 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: dpg | last post by:
How do site searches work? I want to create a MySQL database with a field called "keywords". Then a form with a search phrase input box. I can't figure how to get the results with multiple...
4
by: ash | last post by:
I want search phrase in html file and mark (like Google when I click on "cached") it (phrase). Does somebody know any class, that can help me? Maybe somebody know how could I make this? thanks
0
by: Follower | last post by:
Hi, I am working on a function to return extracts from a text document with a specific phrase highlighted (i.e. display the context of the matched phrase). The requirements are: * Match...
2
by: Michi | last post by:
Hello, I am creating a databse with a large number of text (or blob?) entries. I want users to be able to search these fields. An example would be a forum or journal. Indexing every word in...
4
by: Michi | last post by:
I was wondering what the best solution is for making large numbers of TEXT (or BLOB?) fields searchable. For example, if I have a forum, what is the best way to be able to search for specific...
9
by: Jack-of-all-traits | last post by:
I have certain words, or groups of words (4 or less) input in my fields in Access 2002 xp pro atmosphere. The data is essentially in the tables., so what I want to do is get access with the...
5
by: sree078 | last post by:
Hi I've a list of Values with varchar field in main in a table. I wanted to have fast search as there are very less insertions/updations. Thought to do a FullText Searching on that varchar field....
3
by: Cli | last post by:
Is it possible to search for exact phrases which include a digit. e.g. "Dublin 1" vrs "Dublin 2" using Mysql fulltext search? As far as I can tell the digits are considered stop words ( too...
12
by: Alexnb | last post by:
This is similar to my last post, but a little different. Here is what I would like to do. Lets say I have a text file. The contents look like this, only there is A LOT of the same thing. () A...
0
by: veera ravala | last post by:
ServiceNow is a powerful cloud-based platform that offers a wide range of services to help organizations manage their workflows, operations, and IT services more efficiently. At its core, ServiceNow...
0
by: VivesProcSPL | last post by:
Obviously, one of the original purposes of SQL is to make data query processing easy. The language uses many English-like terms and syntax in an effort to make it easy to learn, particularly for...
0
by: mar23 | last post by:
Here's the situation. I have a form called frmDiceInventory with subform called subfrmDice. The subform's control source is linked to a query called qryDiceInventory. I've been trying to pick up the...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
by: jimatqsi | last post by:
The boss wants the word "CONFIDENTIAL" overlaying certain reports. He wants it large, slanted across the page, on every page, very light gray, outlined letters, not block letters. I thought Word Art...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.