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