I used CGridView and when i filter with dot or comma character it shows error as,
[b]Error 500: <h1>CDbException</h1>
<p>CDbCommand failed to execute the SQL statement: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘’ at line 1. The SQL statement executed was:[/b]
is there any validation or something else as it not throws the error.
i use ‘dataProvider’=>$model->search() as dataProvider, but the function search in model is not generate by crude, i just created for my own way for customized filter and sorting . i think the problem was somewhere there so i create function as searchModel() what i use same as crude generates and use that as dataProvider ("‘dataProvider’=>$model->searchModel()") and it works. now i can filter on special characters.