2. PHPRunner General questions
  3. Search for ' (Single Quote) fails
This topic is locked

Search for ' (Single Quote) fails

 		2/22/2007 11:32:38 AM
PHPRunner General questions
G
 GeddyLee author

Using version 3.1 Build 198.
Don't know if this has been patched already or not, couldn't find any other threads on the subject.
When users search for ' (single quote) like O'Conner or whatever an error occurs. For now I told them to use the \ (backspace) to escape the quote but I would prefer that they didn't have to do this?
So:

1)has this been fixed already? if not:

2)is there an easy fix that I'm not thinking of? if not:

3)could this be fixed in an upcoming build?
Thanks a lot

-Brent
Alexey admin 2/26/2007

Brent,
thank you for pointing me to this bug.

We'll fix it with the next update of PHPRunner
To get your project working now modify commonfunctions.php file in C:\Program Files\PHPRunner3.1\source\include folder.

Find thius snippet there:

else if(!IsDateFieldType($type))

$sSearchFor=db_addslashes($sSearchFor);

and replace it with:

else if(!IsDateFieldType($type) || $strSearchOption=="Contains" || $strSearchOption=="Starts with ..." )

$sSearchFor=db_addslashes($sSearchFor);
G
 		GeddyLee author 2/28/2007

Thanks, I'll give that a shot