Warm tip: This article is reproduced from serverfault.com, please click

coldfusion-Queryappend的任何自定义函数

(coldfusion - Any custom function for Queryappend)

发布于 2020-12-10 11:13:30

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

提前致谢

Questioner
Ritu
Viewed
0
user12031119 2020-12-11 10:27:18

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