Re: RecordCount of query group
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? > > >#Name#, #RecordCount# > >#SubName#, #RecordCount# > > > > 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
Re: RecordCount of query group
Baz wrote: > You could create a counter: That's how I generally do it but if you need the count at the beginning of the group, or during the output of the group, then your alternative would be to pass the query to a UDF that you write whose sole purpose is to determine the count of the current group, using a query of queries. select count(*) AS CNT from qry where #fieldname# = Then, in your output, you can just call the UDF to get the record count. Might have to put some logic around it to only call it once per grouping... Rick ~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:233705 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
RE: RecordCount of query group
You could create a counter: #Name#, #RecordCount# #SubName#, #RecordCount# 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? #Name#, #RecordCount# #SubName#, #RecordCount# 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
RE: RecordCount of query group
Is it possible to get the RecordCount of cf query group? #Name#, #RecordCount# #SubName#, #RecordCount# 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. #Name# #SubName# GroupCount = #groupCount# -- 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