Yes, but it should be noted that it will not accept ANY Zend_Db_Select
object. The object passed to the setRowCount() must contain the
ROW_COUNT_COLUMN = 'zend_paginator_row_count', or else it will throw an
exception.
In my opinion count function, that actually performs the count operation,
should wrap the Zend_Db_Select object that is passed to the
Zend_Paginator_Adapter_DbSelect with a select statement like :
"SELECT count(*) as count from ( ...pased select) as select; "
Matthew Ratzloff wrote:
>
> 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.
>>
>>
>
>
--
View this message in context:
http://www.nabble.com/-Zend_Paginator--Bug-when-using-complex-Zend_Db_Select-tp20561842p20574556.html
Sent from the Zend Framework mailing list archive at Nabble.com.
