Re: Forum Advanced Search
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.
Re: Forum Advanced Search
ok...
so how do we escape that character in the forums search?
Re: Forum Advanced Search
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.
Re: Forum Advanced Search
Actually its a MySQL database so using wildcard characters for that in php should return the results you want.
Re: Forum Advanced Search
Quote:
Originally Posted by RobDog888
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?
Re: Forum Advanced Search
Enclose it in double quotes.
"Form1_KeyDown"
produces expected search results.
Re: Forum Advanced Search
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.
1 Attachment(s)
Re: Forum Advanced Search
Re: Forum Advanced Search
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.
Re: Forum Advanced Search
Strange that I did get some results when I made that post but now I do not. I must have made a mistake. Sorry.
Re: Forum Advanced Search
I think this is protection against sql injections.
Re: Forum Advanced Search
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