^ pop-out codeShare ^
  1. <cfset variables.arFeeds = ArrayNew(1)>
  2. <cfset arrayAppend(variables.arFeeds,"http://feeds.feedburner.com/RaymondCamdensColdfusionBlog")>
  3. <cfset arrayAppend(variables.arFeeds,"http://www.forta.com/blog/rss.cfm?mode=short")>
  4. <cfset variables.rss = createObject("component","rss")>
  5. <cfset variables.arEntries = ArrayNew(1)>
  6. <cfloop from="1" to="#arrayLen(variables.arFeeds)#" index="variables.i">
  7.     <cfset arrayAppend(variables.arEntries,variables.rss.getEntries(variables.arFeeds[variables.i]))>
  8. </cfloop>
  9. <cfquery name="pipeSelect" dbtype="query">
  10. <cfloop from="1" to="#arrayLen(variables.arFeeds)#" index="variables.i">
  11.     <cfswitch expression="#variables.i#">
  12.         <cfcase value="1">
  13.         <cfset qry1 = arEntries[variables.i]>
  14.         SELECT qry1.title,
  15.             qry1.[date],
  16.             qry1.description,
  17.             qry1.link
  18.         FROM qry1
  19.         </cfcase>
  20.         <cfcase value="2">
  21.         <cfset qry2 = arEntries[variables.i]>
  22.         SELECT qry2.title,
  23.             qry2.[date],
  24.             qry2.description,
  25.             qry2.link
  26.         FROM qry2
  27.         </cfcase>
  28.     </cfswitch>
  29.     <cfif variables.i neq arrayLen(variables.arFeeds)>
  30.     UNION
  31.     </cfif>
  32. </cfloop>
  33.     ORDER BY [date] desc
  34. </cfquery>
  35. <cfoutput query="pipeSelect">
  36. <p style="font-family: Verdana;"><a href="#pipeSelect.link#">#pipeSelect.title#</a>
  37. on #dateFormat(pipeSelect.date,"short")# #timeFormat(pipeSelect.date,"short")#<br />
  38. #pipeSelect.description#</p>
  39. </cfoutput>