Condition Relational Query Error

Yii 1.1 General Discussion
1

hi…

i have relational between 2 tables. sylabus.subject_id referenced to subject.id. so i have reational generated by yii


'silabuses' => array(self::HAS_MANY, 'Silabus', 'matakuliah_id'

how do i get record with condition subject.id=sylabus.subject_id?

i have tried this


'silabuses' => array(self::HAS_MANY, 'Silabus', 'matakuliah_id',

				'condition'=>'silabus.matakuliah_id=:code',

				'params'=>array(':code'=>'id'),

but got an error


CDbCommand failed to execute the SQL statement: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'silabus.matakuliah_id' in 'where clause'. The SQL statement executed was: SELECT `t`.`id` AS `t0_c0`, `t`.`matakuliah` AS `t0_c1`, `silabuses`.`id` AS `t1_c0`, `silabuses`.`matakuliah_id` AS `t1_c1`, `silabuses`.`silabus` AS `t1_c2` FROM `matakuliah` `t` LEFT OUTER JOIN `silabus` `silabuses` ON (`silabuses`.`matakuliah_id`=`t`.`id`) WHERE (silabus.matakuliah_id=:code)

thank you in advance.

2

change this


'condition'=>'silabus.matakuliah_id=:code'

to this


'condition'=>'silabuses.matakuliah_id=:code'
3

Hi

Your Relation Name is silabuses so use


 	'condition'=>'silabuses.matakuliah =:code',

instead of


 	'condition'=>'silabus.matakuliah_id=:code',
4

hello… it works… :)

thank you very much Orey and Nisanth…