[epidemik]

I am querying the years that is posted. The issue that I am having or the goal that I am trying to accomplish is getting the year to only appear once instead of multiple times. The way I dreamed to have it function is that it would list the year if it has any post associated with that year. Any sugestions or tutorials or examples that I can use to accomplish this task.

right now all the post are posted with the year 2011, so now for each post it post 2011 under the navigation bar.

Hopefully everything stated is clear.

<cfquery name="years" datasource="#dsn#">
SELECT year_posted, featured_posted
FROM Featured_artist
GROUP BY year_posted
ORDER BY year_posted DESC

</cfquery>
<center>
<cfoutput query="years">
<a href="feat_archived.cfm?yr=#DateFormat(featured_posted,'yyyy')#">#DateFormat(featured_posted,'yyyy')#</a> <br />
</cfoutput>
</center>

the output show multiple year 2011 in stead of one.

I would like for it to be listed from the most recent year as below:

2013
2012
2011

[Craig328]

epidemik, on 17 February 2011 - 06:42 PM, said:

I am querying the years that is posted. The issue that I am having or the goal that I am trying to accomplish is getting the year to only appear once instead of multiple times. The way I dreamed to have it function is that it would list the year if it has any post associated with that year. Any sugestions or tutorials or examples that I can use to accomplish this task.

right now all the post are posted with the year 2011, so now for each post it post 2011 under the navigation bar.

Hopefully everything stated is clear.

<cfquery name="years" datasource="#dsn#">
SELECT year_posted, featured_posted
FROM Featured_artist
GROUP BY year_posted
ORDER BY year_posted DESC

</cfquery>
<center>
<cfoutput query="years">
<a href="feat_archived.cfm?yr=#DateFormat(featured_posted,'yyyy')#">#DateFormat(featured_posted,'yyyy')#</a> <br />
</cfoutput>
</center>

the output show multiple year 2011 in stead of one.

I would like for it to be listed from the most recent year as below:

2013
2012
2011

<cfquery name="years" datasource="#dsn#">
SELECT year_posted, featured_posted
FROM Featured_artist
GROUP BY year_posted
ORDER BY year_posted DESC
</cfquery>

<cfquery name="dYears" dbtype="query">
SELECT DISTINCT featured_posted
FROM years
ORDER BY featured_posted DESC
</cfquery>

<center>
<cfoutput query="dYears">
<a href="feat_archived.cfm?yr=#DateFormat(featured_posted,'yyyy')#">#DateFormat(featured_posted,'yyyy')#</a> <br />
</cfoutput>
</center>

Try that and see how that works for you.

[epidemik]

Craig328, on 18 February 2011 - 06:26 AM, said:

epidemik, on 17 February 2011 - 06:42 PM, said:

I am querying the years that is posted. The issue that I am having or the goal that I am trying to accomplish is getting the year to only appear once instead of multiple times. The way I dreamed to have it function is that it would list the year if it has any post associated with that year. Any sugestions or tutorials or examples that I can use to accomplish this task.

right now all the post are posted with the year 2011, so now for each post it post 2011 under the navigation bar.

Hopefully everything stated is clear.

<cfquery name="years" datasource="#dsn#">
SELECT year_posted, featured_posted
FROM Featured_artist
GROUP BY year_posted
ORDER BY year_posted DESC

</cfquery>
<center>
<cfoutput query="years">
<a href="feat_archived.cfm?yr=#DateFormat(featured_posted,'yyyy')#">#DateFormat(featured_posted,'yyyy')#</a> <br />
</cfoutput>
</center>

the output show multiple year 2011 in stead of one.

I would like for it to be listed from the most recent year as below:

2013
2012
2011

<cfquery name="years" datasource="#dsn#">
SELECT year_posted, featured_posted
FROM Featured_artist
GROUP BY year_posted
ORDER BY year_posted DESC
</cfquery>

<cfquery name="dYears" dbtype="query">
SELECT DISTINCT featured_posted
FROM years
ORDER BY featured_posted DESC
</cfquery>

<center>
<cfoutput query="dYears">
<a href="feat_archived.cfm?yr=#DateFormat(featured_posted,'yyyy')#">#DateFormat(featured_posted,'yyyy')#</a> <br />
</cfoutput>
</center>

Try that and see how that works for you.

thanks it worked perfectly