Found Number of Rows in Doctrine 2.1

Does anyone know how to retrieve the found number of rows in Doctrine 2.1? I am not referring to the number of results returned but the total given a limit and offset.


Is that information even returned in a regular query? Unless of course you ‘select’ SQL_CALC_FOUND_ROWS too ?

No, its not returned unless you use SQL_CALC_FOUND_ROWS followed by a query for FOUND_ROWS(). Still its hard to believe Doctrine does not have a method or something to take care of it on the Query object. I can paginate without it but can not build a user friendly, sliding navigation for the pagination unless the total number of found rows is known.