CDbCriteria join problem with users table

[Nokia555 (Jlepik442)]

Hello,

i have a problem with CDBCriteria, it seems it can’t get users table and name column.

The code:

$criteria = new CDbCriteria();

    $criteria->join = "LEFT JOIN users ON users.id = userID";


    $criteria->join .= " LEFT JOIN xxx ON xxx.id = type ";


    $criteria->select = "t.*, xxx.title as type, users.name";


    





    $models = xxx::model()->findAll($criteria);





    $this->render('index', array(


    'messages' => $models,


    'pages' => $pages,


    'xxx' => $this->xxx()


    ));

In view:

<div class="info_type"><div class="<?=$message["type"];?>"><?php echo $message["type"]; ?></div></div>

<div class="name"><?php echo $message["name"]; ?></div>

Error:

Description

Property "xxx.name" is not defined.

Any ideas?

[samdark (Alexander Makarov)]

Do you have name property in your xxx model?

[tushar.barate (Tushar Message88)]

yes i have a same error.

[fareed54313 (Fareed)]

Do you have name property in your xxx model?

Steps to add fields in the serch should have the following

1. public variable

2. add the field name in rules method in safe array

3. write you condition for fetch the result

Example :

$public $var;

public function rules()

{

array(‘var’, ‘safe’, ‘on’=>‘search’)

}

if 1, 2 are fail this error will be raised.

"variable var not defined".