<cfset variables.arFeeds = ArrayNew(1)>
<cfset arrayAppend(variables.arFeeds,"http://feeds.feedburner.com/RaymondCamdensColdfusionBlog")>
<cfset arrayAppend(variables.arFeeds,"http://www.forta.com/blog/rss.cfm?mode=short")>
<cfset variables.rss = createObject("component","rss")>
<cfset variables.arEntries = ArrayNew(1)>
<cfloop from="1" to="#arrayLen(variables.arFeeds)#" index="variables.i">
<cfset arrayAppend(variables.arEntries,variables.rss.getEntries(variables.arFeeds[variables.i]))>
</cfloop>
<cfquery name="pipeSelect" dbtype="query">
<cfloop from="1" to="#arrayLen(variables.arFeeds)#" index="variables.i">
<cfswitch expression="#variables.i#">
<cfcase value="1">
<cfset qry1 = arEntries[variables.i]>
SELECT qry1.title,
qry1.[date],
qry1.description,
qry1.link
FROM qry1
</cfcase>
<cfcase value="2">
<cfset qry2 = arEntries[variables.i]>
SELECT qry2.title,
qry2.[date],
qry2.description,
qry2.link
FROM qry2
</cfcase>
</cfswitch>
<cfif variables.i neq arrayLen(variables.arFeeds)>
UNION
</cfif>
</cfloop>
ORDER BY [date] desc
</cfquery>
<cfoutput query="pipeSelect">
<p style="font-family: Verdana;"><a href="#pipeSelect.link#">#pipeSelect.title#</a>
on #dateFormat(pipeSelect.date,"short")# #timeFormat(pipeSelect.date,"short")#<br />
#pipeSelect.description#</p>
</cfoutput>