This topic is locked

Possible search bug?

10/9/2008 6:59:12 AM
PHPRunner General questions
J
jlagden author

Hi,
I been testing the searches on my project and noticed a possible bug. When I do a search on text field using the equals option, the SQL that gets sent does an upper() on the field, but doesn't do it on the text I've entered, so you don't get a non - case sensitive search, you have to type your text in capitals to get a match.
However, on an advanced search, doing exactly the same thing, it looks like an upper is performed on both, giving you a search which is non case sensitive.
I'm currently using phprunner 4.2 so I'll give v5 a go, has anyone else got this problem though?

J
Jane 10/10/2008

Hi,
search is not case-sensitive on the PHPRunner-created pages.

To turn on case-sensitive search open generated include/dbconnection.php file, find and edit db_upper function.

function db_upper($dbval)

{

return $dbval;

}