Queryappend在Coldfusion中-18,而不在Coldfusion中-16。
谁能为“ Queryappend”建议任何自定义的Coldfusoin函数
假设我有2个查询:
Query-1
select * from user where userid > 10 order by userid asc
Query-2
select * from user where userid < 10 order by userid desc
Query append should return folowing:
userid username
11 AA
12 BB
13 CC
9 MM
8 NN
7 OO
提前致谢
queryAppend()
在早期版本的ColdFusion中,最简单,最易读的解决方案是使用查询查询(qoq
),然后使用该union all
功能qoq
通过不提供ORDER BY
子句来附加结果。
<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>
这是要点的工作示例https://trycf.com/gist/484d3ab19f52d81867dacdced47fad09/lucee5?theme=monokai