Problems in pagination - Flexigrid - SQL Server 2005

[eluser]Leandro AR[/eluser]
I'm using the grid flexigrid in a database SQL Server 2005.
I am currently having problems with the pagination.

Someone found a solution for this problem ?

I know that the problem is the limit, but I solve it ?

Thanks,
Leandro.

CI 1.7.1
PHP 5.2.6
SQL Server 2005 ( driver mssql )

[eluser]graf[/eluser]
MSSQL Pagination is a must... how are other MVC, multi-db platforms performing this type of action?

I've supported codeigniter for a while but as my clients have went from local bands to national companies i'm forced more and more to integrate codeigniter with mssql databases.

What is it going to take get the codeigniter guru's to develop this functionality and release it in a future release?

i do notttttt want to move to another platform... I <3 Codeigniter.

I'm needing a pagination work around before the backend to my sites gets to big.. right now having 5-15 entries on the backend is ok but as soon as my clients start hitting 25+ entries the scrolling & load times is gonna be a problem.

Is there anything i can do to help stimulate a solution for this functionality?

We need a MS/MSSQL expert to let us know the proper sql'n used in MS-CMS and such platforms that have pagination available in this DB suite.

[eluser]Leandro AR[/eluser]
For example, this code work fine and give me a rows 10 to 20. Changing this values, I'm simulate a limit of mysql.

Code:

SELECT *
      FROM
          ( SELECT *, ROW_NUMBER() OVER (ORDER BY id) as NroFila

            FROM  $tableXXX

           ) AS PAG_TABLEXXX

      WHERE
      NroFila BETWEEN 10 AND 20

Now, how adapted this code to mssql_driver.php -> function _limit($sql, $limit, $offset) ?

Thanks,
Leandro.