I used group attribute within cfoutput tag to group by AType
and BType and
tried to get the record count of Btype group there, but I got
all record if I use #TEST.recordcount# within the BType group
how can I get a recordcount just for BType?
There is not automatic ColdFusion feature to get a record
count of a
subset of a query. You can build this into your query or your
simple option for your loop would be this. Modify as needed
each inner loop.