Counting output records/rows that have been grouped

[rosn459]

I need to include sequential record numbers in my cfoutput for data that has been grouped according to my customer's requirements.

How would I do this with CF?

<cfoutput>
(Ex:
Area One
1 Name1 HireDate1 Address1
2 Name2 HireDate2 Address2
Area Two
1 Name1 HireDate1 Address1
2 Name2 HireDate2 Address2
</cfoutput>

 

[philhege]

Set a counter. Use the GROUP attribute of CFOUTPUT to display information by area. Increment the counter within the sub-CFOUTPUT section.

Phil Hegedusich
Senior Web Developer
IIMAK

http://www.iimak.com

-----------
Boy howdy, my Liberal Studies degree really prepared me for this....

 

[rosn459]

Ah! A counter. Thanks very much!!!

 

[philhege]

Back with a bit more detail.


<cfoutput query="myquery" group="area">

#Area#
<cfset counter=0>
<cfoutput>
<cfset counter=counter+1>
#counter# #name# #hiredate# #address#<br>
</cfoutput>
</cfoutput>

HTH,

Phil Hegedusich
Senior Web Developer
IIMAK

http://www.iimak.com

-----------
Boy howdy, my Liberal Studies degree really prepared me for this....