J1.5 talk:Using JPagination in your component

2009-10-28T11:49:55Z

Crispy:

This code does not work correctly as it stores the limitstart into a session variable.
So, when clicking upon the first item in your pages list, no limitstart variable is present and so the previously saved limitstart value is reused.

ie. you can go to pages 2, 3, etc. but not back down to 1.

A work around I have used is to always get the value from the Request object.

//$limitstart = $mainframe->getUserStateFromRequest($option.'.limitstart', 'limitstart', 0, 'int');

$limitstart = JRequest::getVar('limitstart',0);

Confirmed and fixed. Thanks. [[User:Chris Davenport|Chris Davenport]] 23:03, 31 May 2009 (UTC)

I have one question

The example changes to the model seem to call the query twice, once with and once without the LIMIT. Should this not use the same SQL_CALC_FOUND_ROWS method mentioned in the "Examples with JDatabase" section? [[User:Crispy|Crispy]] 11:49, 28 October 2009 (UTC)

Joomla! Documentation - User contributions [en]

J1.5 talk:Using JPagination in your component