macromedia.coldfusion.cfml_general_discussion
[Top] [All Lists]

Re: Output issue while grouping

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>