I have a page that has four queries. One gets a list of council names, the
other three get documents that are either live, archived or awaiting
approval. So, as you can see by my code below, I have X tables depending on
how many councils there are. Each table group has three rows that have the
links to the documents. It is working well except that each council shows
ALL of the documents that are getting called. For instance, the first two
table groups should have no documents since there are none for that council,
and the third table group should have documents. I tried to do a cfoutput
inside the loop using a group attribute, but no joy. How to do this?
<table width="100%" align="center" border="1" cellpadding="2"
cellspacing="2">
<cfoutput query="getCouncilNameRet">
<tr>
<td colspan="2" align="center">
<strong>#Name#'s</strong> Bylaws (current, temp and past)
</td>
</tr>
<tr>
<td align="left">
Current Bylaw
</td>
<td align="left">
<cfloop query="getLIveBylawsRet">
<a href="../Bylaws/#Bylaw_File_Name#" target="_blank">#Bylaw_Name#</a>
#DateFormat(Create_Date, "mm/dd/yy")#
</cfloop>
</td>
</tr>
<tr>
<td align="left">
Archived Bylaws
</td>
<td align="left">
<cfloop query="getArchiveBylawRet">
<a href="../ArchiveBylaws/#Arch_Bylaw_File_Name#"
target="_blank">#Arch_Bylaw_Name#</a> #DateFormat(Create_Date,
"mm/dd/yy")#<BR>
</cfloop>
</td>
</tr>
<tr>
<td align="left">
Pending Bylaw
</td>
<td align="left">
<cfloop query="getTempBylawsRet">
<a href="../tempBylaws/#Temp_Bylaw_File_Name#"
target="_blank">#Temp_Bylaw_Name#</a> #DateFormat(Create_Date,
"mm/dd/yy")#<BR>
</cfloop>
</td>
</tr>
</cfoutput>
</table>
Thanks,
Bruce Sorge
Contractor
City of Los Angeles
Department of Neighborhood Empowerment
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265667
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
