Getting Started Assignment 8-10

Hi thanks for your reaction! I tried looking for spelling errors but didnt find anything.

This is the news.cfm code

<!---Instance newsService--->

<cfset newsService = createObject('component', 'cfTraining.components.newsService') />

<!---Get news years--->

<cfset rsNewYears = newsService.getNewsYears()/>

<cfmodule template="customTags/front.cfm" title="HD street band - News" >

  <div id="pageBody">

    <div id="calendarContent">

    <cfif isDefined('url.newsID') >

    <!---Output of a single news article--->

    <cfset rsSingleNews = newsService.getNewsByID(url.newsID) />

    <cfoutput>

    <h1>#rsSingleNews.FLD_NEWSTITLE#</h1>

    <p class ="metadata"> Published on #dateformat(rsSingleNews.FLD_NEWSCREATIONDATE, 'mmm dd yyyy')#

    by #rsSingleNews.FLD_USERFIRSTNAME# #rsSingleNews.FLD_USERLASTNAME#</p>

    #rsSingleNews.FLD_NEWSCONTENT#

    </cfoutput>

    <cfelseif isDefined('url.year')>

<cfset rsNewsOfYear = newsService.getNewsForYear(url.year) />

<h1> All the news of year<cfoutput > #url.year#</cfoutput></h1>

      <table>

      <!---Output  news in a table--->

      <cfoutput query="rsNewsOfYear" >

      <tr>

      <td>#dateFormat(FLD_NEWSCREATIONDATE,'mm dd yyyy')#</td>

      <td>#FLD_NEWSTITLE#</td>

      <td><a href= "news.cfm?newsID=#FLD_NEWSID#">Read More</a>></td>

      </tr>

      </cfoutput>

      </table>

    <cfelse>

<!---Get all news--->

<cfset rsAllNews = newsService.getLatestNews()/>

  <h1> News</h1>

  <table>

    <!---Output  news in a table--->

    <cfoutput query="rsAllNews">

      <tr>

      <td>#dateFormat(FLD_NEWSCREATIONDATE, 'mmm dd yyyy')#</td>

      <td>#FLD_NEWSTITLE#</td>

      <td><a href="news.cfm?newsID=#FLD_NEWSID#">Read More</a></td>

      </tr>

    </cfoutput>

  </table>

  </cfif>

</div>

<div id="calendarSideBar">

<h1>News archive</h1>

  <ul>

    <cfoutput query="rsNewsYears" group="fld_newsYear" >

      <li><a href="news.cfm?year=#fld_newsYear#">#fld_newsYear#</a></li>

    </cfoutput>

  </ul>

  <p class="alignRight"> </p>

</div>

  </div>

</cfmodule>

This is the newsService.cfc

<cfcomponent output="false">

<!---getNewsForYear()method --->

<cffunction name="getNewsForYear" access="public" output="false" returntype="query">

<cfargument name="year" type="numeric" required="true" />

<cfset var rsNewsOfYear = ''/>

<cfquery datasource= "hdStreet" name= "rsNewsOfYear">

    SELECT FLD_NEWSTITLE, FLD_NEWSCREATIONDATE, FLD_NEWSID

    FROM TBL_NEWS

    WHERE YEAR(FLD_NEWSCREATIONDATE) = #arguments.year#

    ORDER BY FLD_NEWSCREATIONDATE DESC

    </cfquery>

    <cfreturn rsNewOfYear/>

</cffunction>

<!---getNewsByID()method --->

<cffunction name="getNewsByID" access="public" output="false" returntype="query">

<cfargument name="newsID" type="numeric" required="true" />

<cfset var rsSingleNews = ''/>

<cfquery  datasource= "hdStreet" name= "rsSingleNews">

    SELECT TBL_NEWS.FLD_NEWSID, TBL_NEWS.FLD_NEWSCONTENT, TBL_NEWS.FLD_NEWSTITLE, TBL_NEWS.FLD_NEWSCREATIONDATE, TBL_USERS.FLD_USERFIRSTNAME, TBL_USERS.FLD_USERLASTNAME

    FROM TBL_NEWS INNER JOIN TBL_USERS ON TBL_NEWS.FLD_NEWSAUTHOR = TBL_USERS.FLD_USERID

    WHERE FLD_NEWSID = #arguments.newsID#

    </cfquery>

    <cfreturn rsSingleNews/>

</cffunction>

<!---getLatestNews()method --->

<cffunction name="getLatestNews" access="public" output="false" returntype="query">

<cfset var rsAllNews = ''/>

<cfquery datasource = "hdStreet" name ="rsAllNews" >

SELECT FLD_NEWSTITLE, FLD_NEWSCREATIONDATE, FLD_NEWSID

FROM TBL_NEWS

ORDER BY FLD_NEWSCREATIONDATE DESC

</cfquery>

<cfreturn rsAllNews/>

</cffunction>

<!---getNewsYears()method --->

<cffunction name="getNewsYears" access="public" output = "false" returntype="query">

<cfset var rsNewsYears = ''/>

<cfquery  datasource= "hdStreet" name= "rsNewsYears" >

SELECT YEAR (TBL_NEWS.FLD_NEWSCREATIONDATE) AS fld_newsYear

FROM TBL_NEWS

ORDER BY TBL_NEWS.FLD_NEWSCREATIONDATE DESC

</cfquery>

<cfreturn rsNewsYears/>

</cffunction>

</cfcomponent>