Question
sorting/grouping results with CFDIRECTORY
I am using cfdirectory to list all of the files in a certain
directory and sorting them desc by datelast modified. Here's the
page:
http://www.ucmo.edu/news/releases/releases.cfm?y=2008
What I would like to do is sort them further by month and automatically create headings such as May, April, March, etc. I know how to get the monthasstring (in comments below) but can't get them grouped.
Here's what I use to display this page now:
<cfdirectory action="LIST" name="rel" directory="mydir/mysubdir" sort="month(datelastmodified) desc">
<ul>
<cfoutput query="rel">
<!--- #monthasstring(month(datelastmodified))#<br> --->
<li><img src="/home_images/icons/acrobat.gif" width="16" height="16" class="icon" alt=""> <a href="#y#/#name#" target="_blank">#replace(name,".pdf","")#</a></li>
</cfoutput>
</ul>
What I would like to do is sort them further by month and automatically create headings such as May, April, March, etc. I know how to get the monthasstring (in comments below) but can't get them grouped.
Here's what I use to display this page now:
<cfdirectory action="LIST" name="rel" directory="mydir/mysubdir" sort="month(datelastmodified) desc">
<ul>
<cfoutput query="rel">
<!--- #monthasstring(month(datelastmodified))#<br> --->
<li><img src="/home_images/icons/acrobat.gif" width="16" height="16" class="icon" alt=""> <a href="#y#/#name#" target="_blank">#replace(name,".pdf","")#</a></li>
</cfoutput>
</ul>
AdChoices