News Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Anis Ahmad's Blog:
Join Problems with Zend_Paginator and Zend_Db_Select objects
August 28, 2008 @ 11:18:55

Anis Ahmad had a problem. The Zend_Paginator component of the Zend Framework, while powerful, wasn't quite working right. Bugs popped up when he used a join along with a Zend_Db_Select.

One of the 4 Adapters for Zend_Paginator is DbSelect which uses a Zend_Db_Select instance. Now, the problem occurred if I need to have some calculative data from other tables and use join with the Zend_Db_Select object for them.

He gives an example of a join that he performed with the component, the details of the "behind the scenes" code and why it happened that way. He also offers a solution (before the Zend_Pagination component was patched for it, of course) of changing the count() method it uses slightly to remove an unneeded part of the query.

0 comments voice your opinion now!
zendpaginator zenddbselect component zendframework


blog comments powered by Disqus

Similar Posts

ProDevTips Blog: Nice ZF, jQuery and Smarty combo

Community News: Andi Gutmans to Present at AjaxWorld 2007

Juozas Kaziukenas' Blog: Starting with Zend_Search_Lucene

Chris Hartjes' Blog: The Story and Rebirth Of Zend_Service_Audioscrobbler, Part 1

Zend Developer Zone: Zend Framework's MVC Introduces the ViewRenderer


Community Events





Don't see your event here?
Let us know!


series framework language code unittest list laravel podcast api interview community developer threedevsandamaybe symfony2 introduction opinion install refactor testing release

All content copyright, 2014 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework