interested. I'll try the UNION now.
<cffunction name="concatenateQueries" access="public" returntype="query" output="false">
<cfargument name="query1" required="yes" type="query">
<cfargument name="query2" required="yes" type="query">
<cfset var concatenateQueriesReturn=queryNew(query1.columnList)>
<cfset var idx=1>
<cfset var columnName=''>
<cfloop from="1" to="#Arguments.query1.recordCount#" index="idx">
<cfset queryAddRow(concatenateQueriesReturn)>
<cfloop list="#Arguments.query1.columnList#" index="columnName">
<cfset querySetCell(concatenateQueriesReturn, columnName, Arguments.query1[columnName][idx])>
</cfloop>
</cfloop>
<cfloop from="1" to="#Arguments.query2.recordCount#" index="idx">
<cfset queryAddRow(concatenateQueriesReturn)>
<cfloop list="#Arguments.query2.columnList#" index="columnName">
<cfset querySetCell(concatenateQueriesReturn, columnName, Arguments.query2[columnName][idx])>
</cfloop>
</cfloop>
<cfreturn concatenateQueriesReturn>
</cffunction>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
