I just want to be clear that setRowCount() accepts either an integer or Zend_Db_Select object for the TOTAL row count. -Matt
On Tue, Nov 18, 2008 at 12:06 PM, Iulian M <[EMAIL PROTECTED]> wrote: > > > > Thank you for your answer. > > I will consider the situation in which i will pass the calculated rowCount. > > > Iulian > > > Matthew Ratzloff wrote: > > > > The easiest way to solve this is to pass in your own Zend_Db_Select COUNT > > query to Zend_Paginator_Adapter_DbSelect::setRowCount(). > > > http://framework.zend.com/svn/framework/standard/trunk/library/Zend/Paginator/Adapter/DbSelect.php > > > > Hope that helps, > > > > -Matt > > > > On Tue, Nov 18, 2008 at 7:32 AM, Iulian M <[EMAIL PROTECTED]> > wrote: > > > >> > >> I am creating a Zend_Db_Select statement for this SQL : > >> SELECT table1.a AS a > >> table1.b AS b > >> COUNT(table2.a) -1 as c > >> FROM table1 > >> INNER JOIN table2 ON table1.a = table2.a > >> HAVING c = 1 > >> > >> The select is tested and it worked as expected. > >> > >> The Zend_Db_Select will be used to paginate the result using > >> Zend_Paginator_Adapter_DbSelect. > >> > >> > >> Problem: > >> When Zend_Paginator_Adapter_DbSelect::count() method is executed, to > >> determine the total number of rows that the select will return, an error > >> will be thrown: > >> > >> [message:protected] => SQLSTATE[42S22]: Column not found: 1054 Unknown > >> column 'c' in 'having clause' > >> > >> This is caused by Zend_Db_Select::setRowCount() that creates an special > >> select based on the select defined in Zend_Paginator_Adapter_DbSelect. > >> setRowCount() alters the columns that will be used to run the select and > >> when the fetch is issued the above error will be thrown. > >> > >> > >> > >> > >> > >> > >> -- > >> View this message in context: > >> > http://www.nabble.com/-Zend_Paginator--Bug-when-using-complex-Zend_Db_Select-tp20561842p20561842.html > >> Sent from the Zend Framework mailing list archive at Nabble.com. > >> > >> > > > > > > -- > View this message in context: > http://www.nabble.com/-Zend_Paginator--Bug-when-using-complex-Zend_Db_Select-tp20561842p20567204.html > Sent from the Zend Framework mailing list archive at Nabble.com. > >
