ColdFusion UDF Library - queryConcat
December 16th, 2008
«« Back to ColdFusion Library
Category:
QUERY
Description:
Add two or more queries together.
Parameters:
Returns:
(Query) All passed arguments added together as one.
Requires:
Sample Use:
Copy to Clipboard
Category:
QUERY
Description:
Add two or more queries together.
Parameters:
- QueryObj (Query, required)
Past ast least twice to specify a set of queries to combine as one. Parameter may be added any number of times to join many queries.
Returns:
(Query) All passed arguments added together as one.
Requires:
Sample Use:
Copy to Clipboard
function queryConcat(){
var loop = 0;
var value = queryNew("");
var query = "";
var array = arrayNew(1);
var loop3 = 0;
var loop2 = 0;
for (loop = 1; loop lte arrayLen(arguments); loop = incrementValue(loop)){
if (isQuery(arguments[loop])){
query = arguments[loop];
for (loop2 = 1; loop2 lte listLen(query.columnList); loop2 = incrementValue(loop2)){
if (not listFindNoCase(value.columnList,listGetAt(query.columnList,loop2)))queryAddColumn(value,listGetAt(query.columnList,loop2),array);
}
for (loop2 = 1; loop2 lte query.recordCount; loop2 = incrementValue(loop2)){
queryAddRow(value);
for (loop3 = 1; loop3 lte listLen(query.columnList); loop3 = incrementValue(loop3))querySetCell(value,listGetAt(query.columnList,loop3),query[listGetAt(query.columnList,loop3)][loop2]);
}
}
}
return value;
}
// http://www.programmers.org/index.php/coldfusion-udf-library/?ckey=62&function=queryConcat
