Skip navigation
Currently Being Moderated

cfoutput group

Jan 31, 2008 4:00 PM

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
 
Replies

More Like This

  • Retrieving data ...

Bookmarked By (0)