Actions

J1.5 talk

Difference between revisions of "Using JPagination in your component"

From Joomla! Documentation

Line 13: Line 13:
  
 
I have one question
 
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)

Revision as of 06:49, 28 October 2009

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. 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? Crispy 11:49, 28 October 2009 (UTC)