<!---Query the database--->
<cfquery name="feed" datasource="public_www">
SELECT *
FROM rss_current_news
WHERE active_flag = 1
</cfquery>

<!---begin .xml generation--->

<cfprocessingdirective suppresswhitespace="yes
<cfxml variable="xmlobject" casesensitive="yes">

<rss version="2.0">
<channel>
<title>NCDOC RSS Feed</title>
<link>rss/feed/rssFeed.xml</link>
<description>RSS Feed for Current News </description>
<lastbuilddate>Date and Time of Last Change</lastbuilddate>
<language>en-us</language>

<cfoutput>
              
<cfloop query="feed">
      
<item>
                <title>#XmlFormat(feed.title)#</title>
                <description>#XmlFormat(feed.caption)#</description>
                <date>#XmlFormat(feed.mod_datetime)#</date>
                <link>#XmlFormat(feed.link)#</link>
</item>
      
</cfloop>
      
</cfoutput>
</channel>
</rss>

</cfxml>
</cfprocessingdirective>

<cfoutput>#xmlobject#</cfoutput>

<!---end .xml generation--->

<!---Query the database to get category data--->
<cfquery name="category" datasource="rss_test">
SELECT categoryID, name, active
FROM rss_category
WHERE active = 1
ORDER BY name ASC
</cfquery>

<!---Query the database to get article information--->
<cfquery name="feed" datasource="rss_test">
SELECT *
FROM rss_news
</cfquery>

<cfprocessingdirective suppresswhitespace="yes">
<cfxml variable="xmlobject" casesensitive="yes">

<rss version="2.0">
<channel>
<cf:treatAs xmlns:cf="http://www.microsoft.com/schemas/rss/core/2005">list</cf:treatAs>
<title>NCDOC RSS Feed</title>
<link>rss/feed/rssFeed.xml</link>
<description>RSS Feed for Current NCDOC News </description>
<lastbuilddate>Date and Time of Last Change</lastbuilddate>
<language>en-us</language>
<copyright>© 2009 NCDOC</copyright>
<ttl>10</ttl>
<image>
<title>NCDOC RSS Feed</title>
<link>rss/feed/rssFeed.xml</link>
<url>images/rss_icon.jpg</url>
<width>144</width>
<height>33</height>
<description>RSS Feed for Current NCDOC News</description>
</image>


<cfoutput>
    
<!--- Outer Loop to handle categories--->
<cfloop query="category">
    <item>
        <title>#XmlFormat(category.name)#</title>
    </item>
        <!--- Inner Loop to handle articles--->
            <cfloop query="feed">
            <cfif category.name IS feed.title>
            <item>
                <link>#XmlFormat(feed.url)#</link>
                <description>#XmlFormat(feed.subject)#</description>
                <pubDate>#XmlFormat(feed.add_date)#</pubDate>
                <category>#XmlFormat(category.name)#</category>
            </item>
            </cfif>
            </cfloop>
</cfloop>

</cfoutput>
</channel>
</rss>

</cfxml>
</cfprocessingdirective>

<cfoutput>#xmlobject#</cfoutput>