I want to output something like this :
Region
Site 1
assigned (3) --- the number in () is a count of the type
assigned, etc.
return (2)
Site 2
assigned (2)
in work (5)
The next column would then have a new region, then sites,
then the counts, etc. but I cannot even get the first column to
work.
here is my code :
<cfoutput query="qry" group="region">
#region#<br>
<cfoutput group="site">
#site#
<cfoutput><cfif #type# is "Assigned"><a
href="next_page.cfm">#type#
(#total_activity#</a>)</cfif></cfoutput><br>
<cfoutput><cfif #type# is "Initiated"><a
href="next_page.cfm">#type#
(#total_activity#</a>)</cfif></cfoutput><br>
<cfoutput><cfif #type# is "In Work"><a
href="next_page.cfm">#type#
(#total_activity#</a>)</cfif></cfoutput><br>
<cfoutput><cfif #type# is "Dispositioned"><a
href="next_page.cfm">#type#
(#total_activity#</a>)</cfif></cfoutput><br>
<cfoutput><cfif #type# is "Closed"><a
href="next_page.cfm">#type#
(#total_activity#</a>)</cfif></cfoutput><br>
<cfoutput><cfif #type# is "Returned"><a
href="next_page.cfm">#type#
(#total_activity#</a>)</cfif></cfoutput><br>
</cfoutput>
</cfoutput>
the first part, with the region and first site 1 work, along
with the counts, but the second site 2 does not work, it should
have a different site value along with different counts, but it is
duplicating the first one exactly, and wil not change to the next
value.
What am I doiong wrong, I am trying to follow the previous
post that worked fine, but I cannot get this one to work.
thanks