query with 2 conditions

Archives Yii 1.0.x Discussions
1

I have a table and I want to pass a query with 2 parameters.

I write this


 'select'=>'bk_descr,bk_title',

                'condition'=>array('bk_id=:bk_id','lan_code=:lan_code'),

                 'params'=>array(':bk_id'=>$key->bk_id,':lan_code'=>$plan->lan_code) ));

but it does not work, what is wrong?

Dimis

2

this maybe work for you

‘select’=>‘bk_descr,bk_title’,

            'condition'=>array('bk_id=:bk_id AND lan_code=:lan_code'),


             'params'=>array(':bk_id'=>$key->bk_id,':lan_code'=>$plan->lan_code) ));
3

I don’t think that this works in Yii - unfortunatly :(

You just have to write it like this:

‘condition’=>‘bk_id=:bk_id AND lan_code=:lan_code’,

I actually submitted a ticket about this a couple days ago.

Check it out here:

http://code.google.com/p/yii/issues/detail?id=478#c0

Hopefully this will be implemented.

I guess it would require major work but it would really simplify things a lot

4

what MarcS said is correct better follow it