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

Eran Galperin's Blog: Profiling queries with Zend_Db and optimizing them by hand

Anis Ahmad's Blog: Join Problems with Zend_Paginator and Zend_Db_Select objects

Pádraic Brady's Blog: Complex Views with the Zend Framework - Part 3: Composite View Pattern

Ben Ramsey's Blog: NY Thoughts and Zend_View_Helper Notes

Flexandair.com: Setting Up Zend_Amf


Community Events





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


release unittest symfony language framework wordpress code series api podcast developer community list install application threedevsandamaybe configure library interview introduction

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