Problem with CActiveDataProvider

Yii 1.1 General Discussion
1

Hi. I want to get last 10 records from database by using CActiveDataProvider. Here is my configuration:




	public function actionLast()

	{

		$dataProvider=new CActiveDataProvider('Models',array(

		'criteria'=>array(

			'order'=>'id DESC',

        		'limit'=>10,

			),

		));

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

			'dataProvider'=>$dataProvider

		));

	}

Тhe problem is that CActiveDataProvider returns all the records, not the last 10, but at least they are ordered. Am I missing something with the configuration?

2

What’s the generated SQL? Also, if you don’t want to use pagination, you should configure ‘pagination’=>false.

3

I don’t know if it’s by design… but “limit” functions only if pagination is set to false!

4

That’s because if pagination is not false, the pagination’s limit will be used instead.

5

I tryed this one:




                'pagination'=>array(

                    'pageSize'=>self::PAGE_SIZE,

                    'limit'=>1,

                ),

but I get this error: Property "CPagination.limit" is read only.

6

I set pagination to false and It works fine now. Thank you very much :)

7

@mdombla: for pagination, please set pageSize instead.

8

First let me tell you that this framework is great !!!

I would like to retreive first 100 rows but to display them in pages… 10 items per page…

Something like this would be usable:




                'pagination'=>array(

                    'pageSize'=>10,

                    'maxItem'=>100,

                ),
9

For this special feature, you need to override CActiveDataProvider::calculateTotalItemCount() as:




    protected function calculateTotalItemCount()

    {

        $count=CActiveRecord::model($this->modelClass)->count($this->getCriteria());

        return $count>100 ? 100 : $count;

    }