Would grouping by year and sorted by date work for you?
<cfquery datasource="articles" name="get_articles">
select *,year(date_entered as yr from articles order by date_entered
</cfquery>
<cfoutput query="get_articles" group="yr"">
Year: #yr#
<cfoutput>
#article_title#<br>
</cfoutput>
</cfoutput>
On Dec 17, 2007, at 2:04 AM, John Barrett wrote:
> I have a page that gets article data from a database(I think that
> it is called a master/detail page). I can with help from this list
> display all the articles, but I would like to display the articles
> by year. That is, loop through the article_id for each year(such as
> 1 to 12 for the fist year. I was think that I could use this, but
> it still displays all the articles. Could somebody please help.
> When I take out the "SELECT * FROM articles" I get a "Can not issue
> empty query." error.
> Thanks so much,
> John:
> <cfquery name="get_articles" datasource="articles">
>
> Select article_id, article_title, date_entered from articles
> </cfquery>
>
> <cfquery name = "get_articles"
> dataSource =
> "articles">
> SELECT * FROM articles
> </cfquery>
> <cfloop query =
> "get_articles">
> <cfset Start = 1>
> <cfset End = 12>
>
> </cfloop>
>
> Here is the original code:
> <!--- main Page, to display links--->
> <cfquery name="get_articles" datasource="articles">
> Select article_id, article_title, date_entered from articles
> </cfquery>
>
>
> <cfoutput query="get_articles">
> <a href="complete_article_page.cfm?article_id=#article_id#"
> target="_blank">#article_title#</a><br>
> #date_entered#<p>
> </cfoutput>
>
> <!--- output page, to display articles--->
> <cfquery name="get_articles" datasource="articles">
> Select article_id, article_title, date_entered from articles
> </cfquery>
>
> <cfquery name="get_article" datasource="articles">
> select article_title, article_text, date_entered from articles
> where article_id = '#article_id#'
> </cfquery>
>
> <cfoutput>#get_article.article_title#</cfoutput></p>
> <cfoutput>#get_article.article_text#</cfoutput></p>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:3188
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
