Select Statement Doesn't Work

Yii 1.1 General Discussion
1

Hi,

I add the select-statement to my find function and it doesn’t work.

I get the error message

ActiveRecord “All” doesn’t have the column “c.infitinitv in SELECT”…


$oTop = All::model()->cache(1000)->with($sRelation)->find(array(

	'select'		=>	'c.infinitiv', 			// << doesn't work

	'condition'		=>	"t.phrase LIKE :phrase",

	'params'		=>	array(':phrase' => $sQuery . "%" ),

	'order'		=>	'LENGTH(c.infinitiv) ASC',

	'group'		=>	'c.infinitiv',

	'limit'		=>	'1',

));

this work perfectly!


$oTop = All::model()->cache(1000)->with($sRelation)->find(array(

//	'select'		=>	'c.infinitiv', 			// << doesn't work

	'condition'		=>	"t.phrase LIKE :phrase",

	'params'		=>	array(':phrase' => $sQuery . "%" ),

	'order'		=>	'LENGTH(c.infinitiv) ASC',

	'group'		=>	'c.infinitiv',

	'limit'		=>	'1',

));

Where is the error?