| Subject: | Re: Output issue while grouping |
|---|---|
| From: | "Stressed_Simon" |
| Date: | Mon, 11 Aug 2008 13:08:38 +0000 UTC |
| Newsgroups: | macromedia.coldfusion.cfml_general_discussion |
Your approach is all wrong. You put the group on the outer cfoutput. Then you
put another cfoutput nested inside for the children. I think what I have done
here will work?
<cfquery name="populatemenu" datasource="#DSN#">
SELECT cssmenu.mID,
pagecontent.parentID,
pagecontent.pname,
pagecontent.plink
FROM cssmenu
INNER JOIN pagecontent
ON cssmenu.mID = pagecontent.parentID
ORDER BY cssmenu.mID, pagecontent.parentID
</cfquery>
Output:
<cfoutput query="populatemenu" group="mID">
<p><a href="##" rel="dropmenu#mid#"><img src="images/test.jpg"
style="float:left" valign="top" border="0"></a></p>
<div id="dropmenu#mID#" class="dropmenudiv">
<cfoutput>
<a href="<cfif plink IS
"">?pageID=#pname#<cfelse>#plink#</cfif>"
style="float:left">#pname#</a>
</cfoutput>
</div>
</cfoutput>
|
| <Prev in Thread] | Current Thread | [Next in Thread> |
|---|---|---|
| ||
| Previous by Date: | Re: Output issue while grouping, jgethers |
|---|---|
| Next by Date: | Re: [CF8] java.lang.NullPointerException, JCondo |
| Previous by Thread: | Re: Output issue while grouping, jgethers |
| Next by Thread: | Re: Output issue while grouping, jgethers |
| Indexes: | [Date] [Thread] [Top] [All Lists] |