Is it possible to get the RecordCount of cf query group?
<cfoutput query="getReord" group="Name">
#Name#, #RecordCount#
<cfoutput>
#SubName#, #RecordCount#
</cfoutput>
</cfoutput>
Not automatically the way you are doing it. You can either do something in the
query with group functions, or you can count them in your output.
<cfoutput query="getReord" group="Name">
#Name#
<cfset groupCount = 0>
<cfoutput>
#SubName#
<cfset groupCount = groupCount + 1>
</cfoutput>
GroupCount = #groupCount#
</cfoutput>
--------------
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
---------
| 1 | |
--------- Binary Soduko
| | |
---------
"C code. C code run. Run code run. Please!"
- Cynthia Dunning
Confidentiality Notice: This message including any
attachments is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or
distribution is prohibited. If you are not the
intended recipient, please contact the sender and
delete any copies of this message.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233644
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=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
