文章存档模块功能实现(asp环境sql语句实现)

做blog时时里面要实现一个文章存档功能，调试了一会终于出来了，思路是：

１.第一层先找出都有哪些年，倒序排列

２.第二层统计第一层的年里的月分有多少个，从而得出：YY年MM月(N篇文章)

３.留言以感谢柳永法同志给大家共享代码

Set rsyear=Server.Createobject("Adodb.Recordset")
sql="select year(addtime) as y from BlogArticle group by year(addtime) order by year(addtime) desc "
rsyear.open sql,conn,1,1
do while not rsyear.eof
        Set rsmonth=Server.Createobject("Adodb.Recordset")
        sql="select count(*),month(addtime) from BlogArticle where year(addtime)="&rsyear(0)&" group by month(addtime)  order by month(addtime) desc "
        rsmonth.open sql,conn,1,1
        do while not rsmonth.eof
                content_temp=content
                content_temp=replace(content_temp,"$yearmonth$",rsyear(0) & rsmonth(1))
                content_temp=replace(content_temp,"$yearmonth2$",rsyear(0) & "年" & rsmonth(1) &"月")
                content_temp=replace(content_temp,"$yearno$",rsmonth(0))
                content_all=content_all & content_temp
        rsmonth.movenext
        loop
rsyear.movenext
loop