Re: [fw-mvc] Zend_Paginator and Zend_Db_Table_Select objects

I seem to have lost the ability to post issues in the issue tracker (or am having a really hard time finding the right link to click on). Are members of the "Confluence-users" group allowed to post new issues?

-Hector

Jurriën Stutterheim wrote:

Hi Hector,

Could you report both bugs on the issue tracker please?

You'll be glad to hear that the first bug is known and it's being worked on. The goal is to have it fixed before the official ZF 1.6 release.

On Jul 22, 2008, at 22:31 , Hector Virgen wrote:

Hello,

I just noticed the new components on the online manual and decided to try out the new paginator. Very nice!

I found a couple small bugs that you might want to have a look at:

1) An exception is thrown when using a Zend_Db_Table_Select object: "No table has been specified for the FROM clause". To get around this, I had to call from() on the select object (which is redundant for Zend_Db_Table_Select).

<?php

$table = new MyTable();

$select = $table->select()
->from($table) // required for paginator?
;

$paginator = Zend_Paginator::factory($select);

?>

2) The paginator will break if you set the current page number before setting the item count per page. It seems that setting the page number executes the query to retrieve the items. Is this intentional?

<?php

$page = 1;
$itemsPerPage = 5;

// Not working
$paginator = Zend_Paginator::factory($select);
$paginator->setCurrentPageNumber($page);
$paginator->setItemCountPerPage($itemsPerPage);
$items = $paginator->getItems();  // Incorrectly returns 10 items (the default count per page)

// This works
$paginator = Zend_Paginator::factory($select);
$paginator->setItemCountPerPage($itemsPerPage);
$paginator->setCurrentPageNumber($page); // Must be done last
$items = $paginator->getItems();  // Correctly returns 5 items

?>

Otherwise, the paginator is working nicely and I plan to replace my current poor-boy's paginator with the Zend one very soon :)

-Hector