What database are you using?
This example is for MS SQL Server.
NOTE: convert(varchar, ArticleDate, 112) = yyyymmdd
ORDER BY GroupDate DESC will put the newest articles on top
Your query is like so...
<cfquery name="article_results" datasource="myDSN">
SELECT ArticleID,
ArticleTitle,
ArticleContent,
ArticleDate,
convert(varchar, ArticleDate, 112) AS GroupDate
FROM ArticlesTable
ORDER BY GroupDate DESC
</cfquery>
<cfoutput query="article_results" group="GroupDate">
#DateFormat(GroupDate, "mm/dd/yyyy")#
<ul>
<cfoutput>
#ArticleTitle#<br />
# ArticleContent#
</cfoutput>
</ul>
</cfoutput>
HTH
Chuck
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4762
Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
