name insertion into mysql database

[djtrotman]

My hosting platform blocks input of names like O'BRIEN so in
Row inserting I have entered.
$rsnew['lastname']= mysql_real_escape_string($rsnew['lastname']);
And row rendered
$this->lastname->ViewValue = StripSlashes($this->lastname->ViewValue);
And row selected
$rs['lastname']= stripslashes($rs['lastname']);
Data goes into database ok and displays as O'Brien , the problem have on a search if I enter O'Brien nothing is displayed BRIEN display name ok O'BRIEN

Where do I have to change the input to get the search to work.

[danielc]

To change your searching criteria, use Recordset_Searching server event to change.

[Webmaster]

To change search values, you can also use the Recordset_SearchValidated server event.

[djtrotman]

existing filter displays as lastname LIKE '%o\'mac% - database value is stored as = "o\'mac"
I thought this would have found the entry but comes back no records.

[Webmaster]

If the value is stored as "o\'mac", you should escape the "\" character too in the SQL, i.e.:

lastname LIKE '%o\\\'mac%'