[eluser]nebulom[/eluser]
Though I think it's not related with the Pagination class, I think it's with the construction of the Oracle db driver. I'm not familiar with CodeIgniter's core as I'm a newbie with this framework but I echoed the $sql in the query and it is
Code:
SELECT *
FROM (SELECT inner_query.*, ROWNUM rnum
FROM (SELECT *
FROM "WWW_USER_LEVEL_NAMES"
WHERE "SYSTEM_ID" = 27) inner_query
WHERE ROWNUM < 4)
WHERE rnum >= 2
This should be the second page of 2 per page. I have a query that is working fine and it has this
Code:
select *
from (
select a.*, rownum r
from (
select * from www_user_level_names where system_id = 27
) a
where rownum <= :higherbound
)
where r > (:higherbound - :xlimit)
Where higherbound is 4 and limit is 2 per page. Guys please check as I found the first query to select rows 2 and 3 where it should be selecting 3 and 4. Thanks a lot in advance.