1 Reply Latest reply: Jan 31, 2008 6:08 PM by Dan Bracuk RSS

    cfoutput group

    trojnfn Community Member
      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