Pagination Using Group Output

[stymie]

Does anyone know a workaround for this problem? I need to use the group by
function of cfoutput because I've got a fairly complex query I need to run and
my pagination is all screwy because the record counts are increased because of
the matrixing of the query. So you'll see the same record on back-to-back pages
because ColdFusion thinks the record count from 1-10 is really in fact 1-30
because of the matrixing. Thanks for any help.