剛剛用Yii 的AR 寫的很開心, 下了這個 [sourcecode language='php'] $criteria=new CDbCriteria; $criteria->condition=’products.id=:ID AND products_info.language_id=:languageID’; $criteria->params=array(‘:ID’=>$_GET['id'], ‘:languageID’ => $this->_lang_id ); $criteria->order = ‘products_content.content_orders ASC’; $model = Products::model()->with( ‘products_info’, ‘products_content’ )->find( $criteria ); [/sourcecode] 一直出現 CDbCommand 無法執行 SQL 陳述: SQLSTATE[42S22]: Column not found: 1054 Unknown column ‘products.id’ in ‘where clause’ 想說怪了… 再看了一下 sql log [sourcecode language='text'] 543 Query SELECT `t`.`id` [...]
posted in program by johnpupu