Alternatively, you could probably get the group count into the query result set itself by using
SELECT name, subname, count(subname) as subnameCount, cola, colb, colc from tableName order by name, subname group by name, subname, cola, colb, colc Rick j s wrote: > Is it possible to get the RecordCount of cf query group? > > <cfoutput query="getReord" group="Name"> > #Name#, #RecordCount# > <cfoutput> > #SubName#, #RecordCount# > </cfoutput> > </cfoutput> > > what is returned it the total RecordCount of the query and not the count of > SubNames in each group. > > Total RecordCount: 4 > > Name1 > SubName1 > SubName2 > (total SubName count 2 what is returned is 4) > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233706 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
