Months &Years

[silstorm]

I'm trying to create an archive page of links to articles added to a database,
and I would like to group these by months and years. So, for example my first
page would look something like; April 2005 March 2005 February 2005 January
2005 Decemeber 2004 etc etc Now, the code for displaying the pages thereafter
is no problem (as I can obviously use the month and year as a variable to
search the DB for the articles. What I am having a problem with however is how
can I query the database to simply find out months and years that have entries
, ideally omitting any months that don't. Many Thanks in advance Lee

[KevinOtt]

<cfquery name='GetMonths'> SELECT DISTINCT DATEPART(mm, dteArticle) AS month,
DATEPART(yy, dteArticle) AS year FROM tblArticles </cfquery> The query would
look something like that. When outputting the data you will need to group by
month and perhaps year.