swisscheese
(Swisscheese2122)
August 16, 2011, 4:36pm
1
I have the following and it works fine
$criteria->addCondition('TypeCode ="'.O.'"');
I need to have multiple options here though. If I have this in my controller it works fine
$model->TypeCode = array('A', 'C', 'P', 'S', 'V', 'Z');
I just need help getting this into an addCondition instead though. Failed attempt:
$criteria->addCondition('TypeCode ="'.array('A', 'C', 'P', 'S', 'V', 'Z').'"');
andy_s
(Arekandrei)
August 16, 2011, 6:36pm
2
Try this: http://www.yiiframework.com/doc/api/1.1/CDbCriteria#addInCondition-detail
$criteria->addInCondition('TypeCode', array('A', 'C', 'P', 'S', 'V', 'Z'));
swisscheese
(Swisscheese2122)
August 17, 2011, 3:47am
3
Thanks andy that works. I threw this into my app and it looked just like another attempt I had in there. Although I was using addCondition and not addInCondition.
andy_s
(Arekandrei)
August 17, 2011, 6:05am
4
You can use addCondition, but with many values it is not very handy. SQL IN operator is a better solution there.
ram87
(C Ramkumar)
February 15, 2013, 10:29am
5
i want join query addCondition
$criteria=new CDbCriteria;
$criteria->select=‘date,t.rollno,t.active, t.salary,t.name,t.id, ram_dbs.department’;
$criteria->join=‘INNER JOIN ram_dbs ON ram_dbs.id=t.id’;
$criteria->AddCondition(‘date’=$this->to_date);
RamDbf::model()->findAll($criteria);
is not work…ing
mirunho
(D Mirecki)
February 15, 2013, 11:22am
6
ram87:
i want join query addCondition
$criteria=new CDbCriteria;
$criteria->select=‘date,t.rollno,t.active, t.salary,t.name,t.id, ram_dbs.department’;
$criteria->join=‘INNER JOIN ram_dbs ON ram_dbs.id=t.id’;
$criteria->AddCondition(‘date’=$this->to_date);
RamDbf::model()->findAll($criteria);
is not work…ing
try to replace
$criteria->AddCondition('date'=$this->to_date);
with
$criteria->compare('date',$this->to_date);
hi you can use
$criteria->AddCondition(‘date =’.$this->to_date);