Checked this already.

This is output from getpart.  Sort works on first page only even though
getpart output says differently.

Array ( [0] => Array ( [0] => PHPOID [1] => DESC ) ) 

$select = $db->select()
        ->from (array ('p' => 'PMPPH' ), 
        array ('PHPTYP' => 'p.PHPTYP', 'PHPCO' => 'p.PHPCO', 'PHPOID' =>
'p.PHPOID', 'PHPDSC' => 'p.PHPDSC' ))
        ->where('PHPOID like ?', $pofltrx)
        ->where('translate(PHPDSC) like ?', $descfltrx)                         
        ->where('PHPTYP like ?', $typeselectx)
        ->where ('PHPCO like ?', $compselectx)
        ->order ("$sortField $sortDir");                                        
                         
// Create pager object
$pager = new Zend_Paginator ( 
        new Zend_Paginator_Adapter_DbSelect ($select ));

print_r($select->getPart( Zend_Db_Select::ORDER));                      

        // Set current page                             
        $currentPage = isset ( $_GET ['p'] ) ? ( int ) htmlentities ( $_GET 
['p'] )
: 1;
        $pager->setCurrentPageNumber ( $currentPage );
        
        // Number to dispaly on page
        $itemsPerPage = isset ( $_GET ['c'] ) ? ( int ) htmlentities ( $_GET 
['c']
) : 14;
        $pager->setItemCountPerPage ( $itemsPerPage );
        
        // Pages in page range
        $pager->setPageRange ( 5 );
        
        // Get data
        $pages = $pager->getPages ( 'Sliding' );
                                
-- 
View this message in context: 
http://zend-framework-community.634137.n4.nabble.com/Paginator-bug-tp3165298p3166576.html
Sent from the Zend Framework mailing list archive at Nabble.com.

Reply via email to