无法将数组绑定到CDbCriteria（Yii）

Question

I want to use WHERE IN(array) clause in my query.

$criteria = new CDbCriteria;
$criteria->addCondition('id_cty_cmp IN(:ids)');
$criteria->params = array(':ids' => $ids); // binding array

$cmps = Component::model()
            ->with(array('type', 'values'))
            ->findAll($criteria);

Like this, I get "Array to string conversion" error.

When I used

$criteria->params = array(':ids' => implode(',', $ids));

I got nothing (empty array).

When I don't use binding, it works (but clearly not a good practice):

$criteria = new CDbCriteria;
$criteria->addCondition('id_cty_cmp IN(' . implode(',', $ids) . ')');

Any ideas?

Answer 1

Alright, here's the solution. May it help future googlers.

$criteria = new CDbCriteria;
$criteria->addInCondition('id_cty_cmp', $ids);