• Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
Exit
0

cfoutput group

Participant ,
Jan 31, 2008 Jan 31, 2008

Copy link to clipboard

Copied

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

Views

253

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
LEGEND ,
Jan 31, 2008 Jan 31, 2008

Copy link to clipboard

Copied

LATEST
You have too many cfoutput tags. Plus you don't need octothorps inside cfif tags.

Votes

Translate

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources
Documentation