Skip to content


Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP


CActiveDataProvider with MSSQL, pagination has wrong Offset and Limit on last page #1137

webteb opened this Issue · 3 comments

4 participants


when working with active data provider and pagination, for example with clistview, if my data is from 1 to 12 and page size is 10
then first page shows results from 1-10, and last page shows results from 11 - 12 and from 1 - 8.

a solution was suggested in


Please try my suggestion in #166 (comment) or is unrelated?


@Diego-Rocha linking issues on github is better done like this #166, so github will create a backlink to here.


@Diego-Rocha Your suggestion fixed the issue for me, along with pages not showing different data when a column is selected.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Something went wrong with that request. Please try again.