Hey Ralph thanks for replying. Im using MySQL
I did try changing the alias, but the query ended up being the same just with another alias for categories. I thought it my be a problem with my grouping but the query works well without pagination. I think the adapter should wrap the original select object and alias the COUNT(1) as it does in ZF1, but i wasn't sure to open an issue yet. Thanks. -- View this message in context: http://zend-framework-community.634137.n4.nabble.com/ZF2-Paginator-DbSelect-not-counting-rows-as-expected-tp4658186p4658188.html Sent from the Zend Framework mailing list archive at Nabble.com. -- List: [email protected] Info: http://framework.zend.com/archives Unsubscribe: [email protected]
