user12031119
2020-12-11 10:27:18
The easiest and most readable solution to emulate a queryAppend() in earlier versions of ColdFusion is by using a query of queries (qoq) and then using the union all feature to append the resultant qoq by not supplying an ORDER BY clause.
<cfquery name="query1" datasource="mydatasource">
select * from user where userid > 10 order by userid asc
</cfquery>
<cfquery name="query2" datasource="mydatasource">
select * from user where userid < 10 order by userid desc
</cfquery>
<!--- "Union all" the 2 result sets together in a qoq and don't supply an order by clause --->
<cfquery name="queryAppend" dbtype="query">
select * from query1
union all
select * from query2
</cfquery>
Here's a working sample of the gist https://trycf.com/gist/484d3ab19f52d81867dacdced47fad09/lucee5?theme=monokai