Search Buggy?

[Imar]

Hi there,

How exactly (or roughly) does the search engine work? I think before the new look you could search for about anything you liked. I think the search was implemented as something like (no pun intended) this:

WHERE Body LIKE '%' + searchField + '%'

However, this no longer seems to be the case. I am sure there is a post that deals with window.mm_menu_1120161301_0 (for Dreamweaver menus), but I can no longer find it. Even with mm_menu the relevant posts no longer show up.

Is this a bug? A change in functionality? Right now I use Google to search P2P, but that's not very convenient.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

[happygv]

Yes Imar,

I too have reported on that a few times in my feedback in the other thread, Error in wrox search Page, sometime back, but not sure if something is happening on that.

As you said, that search engine before the site revamp was really searching everything I gave(even if I am lost;)), it wasn't buggy at all.

Cheers!

_________________________
- Vijay G
Strive for Perfection

[bluckcuck]

The search was changed to use full-text indexing about a week after the site redesign. The previous search did use the "... LIKE '%...%'" method but was becoming far too slow (and too intensive on the server - making all of P2P slow). The search now uses "contains(...)" The advantage is that the search completes in seconds, rather than sometimes timing out after a minute.

The side-effect is that the full-text search breaks words on non-letter/number characters. The search function has to filter out common "noise" words (a, and, or, etc.) and characters that break the search (this is what happygv was seeing when searching for things that contained characters like <, /, etc.).

The underscore in your search is probably being filtered strangely. I'll look into it to see if there's a work-around.

What I really need is the "official" list of characters that are allowed as a search phrase for the contains() statement in SQL Server.

Bruce Luckcuck
Director, Applications & Support Services
Wiley Publishing, Inc.

[Hal Levy]

Sounds like a question for the SQL Server forum :)

Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee

[Imar]

Right, I see. That makes a lot of sense.

Don't know the complete list either. Maybe you can search the archives for it ;)

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Lazy Days by Robbie Williams (Track 1 from the album: Life Thru a Lens) What's This?