Yii Criteria >> How to bind parameters for addInCondition and addBetweenCondition?

Yii 1.1 General Discussion
1

As far we know, we can bind parameters for addCondition like below.




$criteria = new CDbCriteria();

$criteria->addCondition('myfield = :myval');

$criteria->params = array(':myval' => 'value');

But… how can we bind parameters for addInCondition and addBetweenCondition?




$criteria = new CDbCriteria();

$criteria->addInCondition('myfield', array('arrval1', 'arrval2', 'arrval3'));

// how to bind parameters for the array values?







$criteria = new CDbCriteria();

$criteria->addBetweenCondition('myfield', 'startval', 'endval');

// how to bind parameters for the between values?

Let me know if you have a solution. Thank you very much.

2

Yes, it is same as I thought. But I had a doubt. Parameters are bind automatically. Below topic verifies it.

http://www.yiiframework.com/forum/index.php/topic/25588-cdbcriteria-addbetweencondition-with-param-binding/

3

Pls. specify your query so that we can find other way.

Select __ from ____ where ____

4 



$criteria->params = array(':startval'=>$startval,':endval'=>$endval);