creating an RSS feed

<cfsetting enablecfoutputonly="yes">

<cfquery name="news_list" datasource="#datasourcename#" blockfactor="100">
SELECT ID, title, content, dateposted, poster, image, layout
FROM news
ORDER BY ID DESC
</cfquery>
<cfsavecontent variable="theXML">
<cfoutput><?xml version="1.0" encoding="ISO-8859-1" ?>
	<!--RSS GENERATED BY FMREHAB.COM ON #now()#-->
	<rss version="2.0">
		<channel>
		<title>#sitename#</title>
		<description>#description#</description>
		<language>en-us</language>
		<copyright>#sitename# 2005</copyright>
		<docs>#address#/rss/</docs>
		<lastBuildDate>#dateFormat(now())# #timeFormat(now())# EST</lastBuildDate>
</cfoutput>
  <cfloop from="1" to="#news_list.recordcount#" index="ctr">
  	<cfscript>
	title = relpace(news_list.title[crt], "<", "<", "ALL");
	content = relpace(news_list.content[crt], "<", "<", "ALL");
	content = relpace(content, "&", "&", "ALL");
	content = relpace(content, "", "'", "ALL");
	date = dateformat(news_list.dateposted[crt], "ddd, dd mmm yyyy");
	poster = relpace(news_list.poster[crt], "<", "<", "ALL");
	</cfscript>
	<cfoutput>
		<item>
		<title>#title#</title>
		<description>#paragraphFormat(content)#</description>
		<link>http://www.fmrehab.com/news.cfm?ID=#ID#</link>
		<author>#poster#</author>
		<pubDate>#date#</pubDate>
		</item>	
	</cfoutput>
  </cfloop>
<cfoutput>
	</channel>
	</rss>
</cfoutput>
</cfsavecontent>

<cfx_filemanager action = "write"

userid = "hidden"

password = "hidden"

file = "#directory#/rss/rss_news.xml"

output = "#thexml#"

>