Mssql Pagination Error.

Yii 1.1 General Discussion
1

When I use relate search on cgridview each page on pagination is same output of first page.

but sorting column on first page is working but when click sort column and then click on other page the error show below

SQLSTATE[HY000] Genaral Error : 10007 the multipart-identifier &quote;name&quote; cloud not be bound 10007

The code I use below

in model action search

public function search() {

    $criteria = new CDbCriteria;


    $criteria->with = array('Employee');


    $criteria->together = true;


    $criteria->compare('t.company_id', $this->company_id, true);


    $criteria->compare('t.internal_code', $this->internal_code, true);


    $criteria->compare('t.payment_condition', $this->payment_condition, true);


    $criteria->compare('t.internal_code', $this->internal_code, true);


    $criteria->compare('t.name', $this->name, true);


    $criteria->compare('t.address', $this->address, true);


    $criteria->compare('t.address_delivery', $this->address_delivery, true);


    $criteria->compare('t.tax_id', $this->tax_id, true);


    $criteria->compare('t.tel', $this->tel, true);


    $criteria->compare('t.fax', $this->fax, true);


    $criteria->compare('t.email', $this->email, true);


    $criteria->compare('t.register_at', $this->register_at, true);


    $criteria->compare('t.payment_condition', $this->payment_condition, true);


    $criteria->compare('t.isActive', $this->isActive);


    $criteria->compare('Employee.firstname', $this->firstname, true);


    


    $sort = new CSort();


    $sort->attributes = array(


        'defaultOrder' => 't.isActive desc',


        // 'defaultOrder'=>'t.firstname desc',


        /*'defaultOrder' => array(


          'asc' => 't.isActive asc',


          ), */


        'name' => array(


            'asc' => 't.isActive desc, t.name',


            'desc' => 't.isActive desc, t.name desc',


        ),


        'company_id' => array(


            'asc' => 't.isActive desc, t.company_id',


            'desc' => 't.isActive desc, t.company_id desc',


        ),


        'internal_code' => array(


            'asc' => 't.isActive desc, t.internal_code',


            'desc' => 't.isActive desc, t.internal_code desc',


        ),


        'email' => array(


            'asc' => 't.isActive desc, t.email',


            'desc' => 't.isActive desc, t.email desc',


        ),


        'register_at' => array(


            'asc' => 't.isActive desc, t.register_at',


            'desc' => 't.isActive desc, t.register_at desc',


        ),


        'payment_condition' => array(


            'asc' => 't.isActive desc, t.payment_condition',


            'desc' => 't.isActive desc, t.payment_condition desc',


        ),


        'isActive' => array(


            'asc' => 't.isActive, t.name asc',


            'desc' => 't.isActive desc, t.name asc',


        ),


        'Employee.firstname' => array(


            'asc' => 't.isActive desc,Employee.firstname',


            'desc' => 't.isActive desc,Employee.firstname desc',


        ),


    );


    return new CActiveDataProvider($this, array(


        'sort' => $sort,


        'pagination' => array(


            'pageSize' => Yii::app()->user->getState('pageSize', Yii::app()->params['defaultPageSize']),


        ),


        'criteria' => $criteria,


    ));


}

But for one table and no relate table no have problem.

Please help me solve this problem.

Thank you very much.