CFOUTPUT GROUP ing max results ??

[Hagster]

Hello All,
Just a question, is there a max number of rows etc that cold fusion can handle in outputing by group from a large query?

I have a query that returns 45631 rows in about 5 seconds it has some joined tables and grouping in the query.

I output the query using two nested groups

CFOUTPUT query="get_data" group="suppname"
Group title

CFOUTPUT group="mpart"
relevant part

CFOUTPUT
all lines from query for that part
/CFOUTPUT

/CFOUTPUT

/CFOUTPUT


My page only seems to output 9999 results when I use GROUP in the output, but if I just output the query with no GROUPING then I get all 45631 results.

Does CF have a limit on the results when GROUPING in a CFOUTPUT?

Kind Regards Guy

[Dan_Bracuk]

How are you counting your outputted results?