yogii
(Azmayogi)
July 19, 2013, 5:45pm
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.
change this
'condition'=>'silabus.matakuliah_id=:code'
to this
'condition'=>'silabuses.matakuliah_id=:code'
nishathul
(Nishathul)
July 20, 2013, 6:05am
3
yogii:
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.
Hi
Your Relation Name is silabuses so use
'condition'=>'silabuses.matakuliah =:code',
instead of
'condition'=>'silabus.matakuliah_id=:code',
yogii
(Azmayogi)
July 20, 2013, 12:41pm
4
hello… it works…
thank you very much Orey and Nisanth…