pagination count and group by

Hey all,

when one paginates with a 'group by' query, then the count results are
worng. Only the count of the first group is returned.

Normally I'd wrap the 'group by' query as a subquery and count those
results, so I set out to do this according to the Book (http://
book.cakephp.org/view/1030/Complex-Find-Conditions). But! I find it a
tad annoying that one needs to provide _all_ information to create the
subquery. (fields, table, alias, limit, offset, joins, conditions,
order, group).
Is there a way to get the query that normally would be executed by a
call to find()?

hh
-Kenny
Cakephp 1.3.2, Apache 2.2

Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions.

You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en