^ pop-out codeShare ^
  1. <cfquery name="pipeSelect" dbtype="query">
  2. <cfloop from="1" to="#arrayLen(variables.arFeeds)#" index="variables.i">
  3.     <cfswitch expression="#variables.i#">
  4.         <cfcase value="1">
  5.         <cfset qry1 = arEntries[variables.i]>
  6.         SELECT qry1.title,
  7.             qry1.[date],
  8.             qry1.description,
  9.             qry1.link
  10.         FROM qry1
  11.         </cfcase>
  12.         <cfcase value="2">
  13.         <cfset qry2 = arEntries[variables.i]>
  14.         SELECT qry2.title,
  15.             qry2.[date],
  16.             qry2.description,
  17.             qry2.link
  18.         FROM qry2
  19.         </cfcase>
  20.     </cfswitch>
  21.     <cfif variables.i neq arrayLen(variables.arFeeds)>
  22.     UNION
  23.     </cfif>
  24. </cfloop>
  25.     ORDER BY [date] desc
  26. </cfquery>