changing column name in GridView with CSqlDataProvider

Yii 1.1 General Discussion
1

I’m using CSqlDataProvider(So I can do joins etc.) instead of CActiveDataProvider for CGridView, but it seems if you use CSqlDataProvider you can’t use ‘$data->’ when referencing values. So if you want to change it will error. (Error=‘Trying to get property of non-object’). Any Ideas?

$this->widget('zii.widgets.grid.CGridView', array(


'id'=>'grade-earned-grid-2',


'dataProvider'=>$dataProvider,


	'columns'=>array(


	'id',


	'last_name',


	array(


		'name'=>'last name',


		//'type'=>'raw',


		'value'=>'$data->last_name'),),

));

2

Welcome to the forum!

For CSqlDataProvider (and CArrayDataProvider) db rows are repesented by arrays instead of objects




'value'=>'$data['last_name'],

/Tommy

3

I try it:




array(

                        'name'=>'maLoaiGD',

                        'filter'=>CHtml::listData(LoaiGiaoDich::model()->findAll(), 'maLoaiGD', 'tenLoaiGD'),

                        'value'=>'LoaiGiaoDich::model()->findByPk($data["maLoaiGD"])->tenLoaiGD',

                ),

but it causes error: Trying to get property of non-object. (I don’t know how to use $data variable)

who can help me? Please.

4

Sorry for the late Thank you. Thanks!