BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 08-07-2006, 11:49 PM   #1 (permalink)
Thumbs Must Hurt
 
Join Date: May 2006
Model: 9300
Carrier: AT&T
Posts: 90
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Can't Search for IM+

Please Login to Remove!

I have been trying to figure out how to search for IM+ issues as I am having some issues and remember seeing a post about this some time ago. But the search functionality drops the IM when I search for IM+.

We should be able to put search terms in quotes for issues like this.
Offline  
Old 08-08-2006, 01:05 AM   #2 (permalink)
BlackBerry God
 
jibi's Avatar
 
Join Date: Oct 2004
Location: Jibi's Secret Place
Model: 8900
OS: 4.6.1.174
Carrier: AT&T
Posts: 11,310
Post Thanks: 0
Thanked 1 Time in 1 Post
Default

special characters cannot be translated in the SQL query code used to search the database, unfortunately. no real way around this. you could try searching for 'shape' and see if anything returns on shape services.
__________________
In the beginning the Universe was created. This has made a lot of people very angry and is widely regarded as a bad move.
Offline  
Old 08-08-2006, 01:16 AM   #3 (permalink)
Thumbs Must Hurt
 
Join Date: May 2006
Model: 9300
Carrier: AT&T
Posts: 90
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by jibi
special characters cannot be translated in the SQL query code used to search the database, unfortunately. no real way around this. you could try searching for 'shape' and see if anything returns on shape services.
Yes, I understand the SQL part. I work with SQL on a daily basis. However, it should at least allow the search for 'IM'. That could be configured to not be a stop word for the fulltext search.
Offline  
Old 08-08-2006, 01:22 AM   #4 (permalink)
Retired BlackBerryForums.com Moderator
 
d_fisher's Avatar
 
Join Date: Oct 2005
Location: Columbus, OH
Model: 9700
OS: SID 6.7
Carrier: AT&T
Posts: 4,455
Post Thanks: 0
Thanked 2 Times in 1 Post
Default

Quote:
Originally Posted by dlbrock
Yes, I understand the SQL part. I work with SQL on a daily basis. However, it should at least allow the search for 'IM'. That could be configured to not be a stop word for the fulltext search.
I think that after the '+' is dropped that 'IM' is too short of a search query.
__________________
Doug

Remember, please try searching first!

Need a screenshot? ... Like JavaLoader?
Try using BBscreen .....Use JL_Cmder!
or BBScreenShooter!

[SIGPIC][/SIGPIC]
Offline  
Old 08-08-2006, 01:26 AM   #5 (permalink)
Thumbs Must Hurt
 
Join Date: May 2006
Model: 9300
Carrier: AT&T
Posts: 90
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by d_fisher
I think that after the '+' is dropped that 'IM' is too short of a search query.
Most Full text search engines have what are called 'Stop Word' lists. These are words that are dropped because they are too common in the english language and the full text collection would be over populated with them if they were not stop words. Since the term IM is so popular with handheld devices I think it makes sense to remove 'IM' from the stop word list if it's possible.

If not, then I will continue to hunt page by page. Thanks for the consideration.
Offline  
Old 08-08-2006, 02:29 AM   #6 (permalink)
BlackBerry God
 
jibi's Avatar
 
Join Date: Oct 2004
Location: Jibi's Secret Place
Model: 8900
OS: 4.6.1.174
Carrier: AT&T
Posts: 11,310
Post Thanks: 0
Thanked 1 Time in 1 Post
Default

traditionally with vBulletin, they've used a built-in search engine function that had min/max values for the number letters - no exclusions or allowances, though. they've added a new search option that uses MySQL's full text searching. supposedly it's faster and less intense on the servers. i'll run this through my own tests, in terms of conversion, etc. and then pass on to Tom to see if he wants to implement it here.
__________________
In the beginning the Universe was created. This has made a lot of people very angry and is widely regarded as a bad move.

Last edited by jibi : 08-08-2006 at 02:50 AM.
Offline  
Old 08-08-2006, 09:56 AM   #7 (permalink)
Thumbs Must Hurt
 
Join Date: May 2006
Model: 9300
Carrier: AT&T
Posts: 90
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by jibi
traditionally with vBulletin, they've used a built-in search engine function that had min/max values for the number letters - no exclusions or allowances, though. they've added a new search option that uses MySQL's full text searching. supposedly it's faster and less intense on the servers. i'll run this through my own tests, in terms of conversion, etc. and then pass on to Tom to see if he wants to implement it here.
I am surprised there isn't a Stopwords list of some sort. If the application won't extend itself to the solution then there is nothing that can be done about it. Thanks for responding.

Doug
Offline  
Old 08-09-2006, 12:36 AM   #8 (permalink)
BlackBerry God
 
jibi's Avatar
 
Join Date: Oct 2004
Location: Jibi's Secret Place
Model: 8900
OS: 4.6.1.174
Carrier: AT&T
Posts: 11,310
Post Thanks: 0
Thanked 1 Time in 1 Post
Default

I just converted my forum to MySQL FullText Indexing/Searching - took about 2-3 minutes (should take quite a bit longer over here). I also had a look at the Message Searching options, which remained the same. I must have overlooked the exclusion list, but there is one present. It still has the min/max values for searching, but there is also the exclusion. I'll present this to Tom with a list of commonly-used 2-letter words to exclude and see if he wants to implement.
__________________
In the beginning the Universe was created. This has made a lot of people very angry and is widely regarded as a bad move.
Offline  
Old 08-09-2006, 12:43 AM   #9 (permalink)
BlackBerry God
 
jibi's Avatar
 
Join Date: Oct 2004
Location: Jibi's Secret Place
Model: 8900
OS: 4.6.1.174
Carrier: AT&T
Posts: 11,310
Post Thanks: 0
Thanked 1 Time in 1 Post
Default

Actually, just found an inclusions list for words no matter the character limit.
__________________
In the beginning the Universe was created. This has made a lot of people very angry and is widely regarded as a bad move.
Offline  
Old 08-09-2006, 10:36 AM   #10 (permalink)
Thumbs Must Hurt
 
Join Date: May 2006
Model: 9300
Carrier: AT&T
Posts: 90
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by jibi
Actually, just found an inclusions list for words no matter the character limit.
That's what I'm talking about! Thanks for digging around. I think it will make a difference.

Regards,

Doug
Offline  
Closed Thread


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On





Copyright 2004-2014 BlackBerryForums.com.
The names RIM and BlackBerry are registered Trademarks of BlackBerry Inc.