rename column in relational query

Hi all,

I have a relational query like:


public function relations()

	{

		return array(

			'file'=>array(self::HAS_MANY, 'Data', 'parent_id',

				'select'=>array('id','label','description','date','path')

			)

		);

	}

I want to rename the ‘label’ to something else like ‘name’. how can I do this?

thanks for any suggestions.

you can change like this:


public function relations()

	{

		return array(

			'file'=>array(self::HAS_MANY, 'Data', 'parent_id',

				'select'=> 'label as name ,*'

			)

		);

	}

Hi, thanks for your quick reply. but the changes does not take any effect.