I have a problem with the params attribute for CActiveDataProvider, when working with the LIKE and ILIKE operators in postgres:
$provider = new CActiveDataProvider( 'Member',
array(
'criteria' => array(
'select' => "id,last",
'condition' => "last ILIKE %:filter%",
'params' => array( ':filter' => 'sam' )
)
)
);
I’ve tried various permutations, with quotes and without, but keep getting SQL errors.
Any ideas?
Thanks,
-queej