You could create a counter: <cfset OuterRecordcount=0 /> <cfoutput query="getReord" group="Name"> <cfset OuterRecordcount=OuterRecordcount+1 /> #Name#, #RecordCount# <cfoutput> #SubName#, #RecordCount# </cfoutput> </cfoutput>
Baz -----Original Message----- From: j s [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 28, 2006 11:11 AM To: CF-Talk Subject: RecordCount of query group 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:233645 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
