Forum Advanced Search

[Pradeep1210]

When I do an advanced search for some text, it doesn't search within some tags.. like CODE, HIGLIGHT etc.

e.g.
I do an advanced search for:
Key Word(s): Form1_KeyDown
User Name: Pradeep1210
Rest everything at default settings.

It shows no records found.

But Have a look at this post:
http://www.vbforums.com/showpost.php...19&postcount=6
It has exactly what I have been searching for, but inside HIGHLIGHT tags.

So what is the correct way to search so that everything inside the post is included in the search including these tags?
Or is this a limitation of the vBulletin boards?


Pradeep

[si_the_geek]

The problem is not the tags, the problem is the _ character; if you search for other items in the code, it works fine.

The _ character (and %) is a wildcard in SQL, which the search almost certainly uses, and I presume that the forum software eliminates it. I just did a quick test (tried to escape it), and it seems that is the case.

[Pradeep1210]

ok...
so how do we escape that character in the forums search?

[si_the_geek]

I've got no idea I'm afraid, the standard SQL method (putting it in square brackets, so it is treated as a character list) doesn't work.

There is likely to be something on vBulletin that explains how to do it.

[RobDog888]

Actually its a MySQL database so using wildcard characters for that in php should return the results you want.

[Pradeep1210]

Actually its a MySQL database so using wildcard characters for that in php should return the results you want.

So what exactly should I type in the forums search textbox so that I get the results I am expecting to see?

[penagate]

Enclose it in double quotes.

"Form1_KeyDown"

produces expected search results.

[Pradeep1210]

NO...
can't still get the link I posted in my first post to be included in the search results. The only result is this thread. I think that's because this thread has that word within double quotes, exactly as I put in the keywords box in post #7. So it is including the double quotes in search.

I tried with :
Key Word(s): "Form1_KeyDown"
User Name: Pradeep1210
Rest everything at default settings.

[Pradeep1210]

[Negative0]

Could it have something to do with the fact that the keydown is immediately followed by a parenthesis? If you do a search for "Me.KeyPreview", which has a space before the equal, you get the thread you are looking for.

[penagate]

Strange that I did get some results when I made that post but now I do not. I must have made a mistake. Sorry.

[TheBigB]

I think this is protection against sql injections.

[Pradeep1210]

Assuming that after the recent upgrade this problem might have been corrected, I tried what I was doing in post #1 again.
Though I don't get what I was expecting, the results were different from previous one. I got this current thread in the search.
So I think Negative0 might be right that it is considering the parenthesis a part of the word and consequently omitting it in the search results.

Pradeep