[vitman]

I want to have something like

$some_values = array(1,2,3,4,5);
Yii::app()->getDb()->createCommand('SELECT x FROM y WHERE z in (:p1)')->bindValuesForInClause(':p1'=>$some_values)->queryAll();

[Rajith R]

use findAll()

[vitman]

Rajith R, on 01 June 2012 - 06:26 AM, said:

use findAll()

Not an answer.

I have some really huge queries with some IN clauses written on pure pl/sql.AR not a solution here.

[alex-w]

If you can use the query builder, http://www.yiiframew...bCommand#where()-detail

[yugene]

vitman, on 01 June 2012 - 05:52 AM, said:

I want to have something like

$some_values = array(1,2,3,4,5);
Yii::app()->getDb()->createCommand('SELECT x FROM y WHERE z in (:p1)')->bindValuesForInClause(':p1'=>$some_values)->queryAll();

Maybe idea from Stackoverflow will be helpful.

[vitman]

Thanks for replies.

BUT is this will not be useful if yii will do it automatically?