CDbCriteria join problem with users table

Nokia555 · August 16, 2010, 5:11pm

Hello,

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

The code:

$criteria = new CDbCriteria();

    &#036;criteria-&gt;join = &quot;LEFT JOIN users ON users.id = userID&quot;;


    &#036;criteria-&gt;join .= &quot; LEFT JOIN xxx ON xxx.id = type &quot;;


    &#036;criteria-&gt;select = &quot;t.*, xxx.title as type, users.name&quot;;


    





    &#036;models = xxx::model()-&gt;findAll(&#036;criteria);





    &#036;this-&gt;render('index', array(


    'messages' =&gt; &#036;models,


    'pages' =&gt; &#036;pages,


    'xxx' =&gt; &#036;this-&gt;xxx()


    ));

In view:

Error:

Any ideas?

samdark · August 17, 2010, 5:57pm

Do you have name property in your xxx model?

tushar.barate · August 1, 2013, 9:14am

yes i have a same error.

fareed54313 · May 6, 2014, 10:42am

Steps to add fields in the serch should have the following

public variable
add the field name in rules method in safe array
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".