GridView type : number

I have a column which integer values…but in search field when I write something different than a number I get database error. I didn’t find a solution yet. I tried something with a cast but I don’t get all the results anymore. There should be another solution.

Thanks,

If you post your code and the error message it may be easier for someone to help you

I resolve this using

if(is_numeric($this->priority) ){ $criteria->compare(‘priority’,$this->priority); }

That’s it…