Controller代码
public function actionIndex() {
$dataProvider=new CActiveDataProvider('Estate',array(
'criteria'=>array('with'=>array('regional','street')),
));
$this->render('index',array(
'dataProvider'=>$dataProvider,
));
}
View代码
<?php $this->widget('zii.widgets.grid.CGridView', array(
'dataProvider'=>$dataProvider,
'columns'=>array(
'name',
'address',
array(
'name'=>'regional_id',
'value'=>'$data->regional->name'
),array(
'name'=>'street_id',
'value'=>'$data->street->name'
),
array('class'=>'CButtonColumn'),
),
)); ?>
现在点name列排序时,会产生错误,信息如下
CDbCommand 无法执行 SQL 语句: SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'name' in order clause is ambiguous