Parameter
Last updated on
Apr 27, 2021
Note:
You can also set the maximum thread count in ColdFusion Administrator. Click Server Settings > Settings and specify the number of threads in Default Maximum Thread Count For Parallel Functions.
Description
Determines if at least one value in a query satisfies a specified condition.
Returns
True if at least one value matches a condition; false, otherwise.
Syntax
querySome(query, function(row [, currentRow] [, query] ){} [, parallel] [, maxThreadCount])
Member function
queryObj.Some(closure)
History
ColdFusion (2021 release): Introduced the following parameters:
- parallel
- maxThreadCount
New in ColdFusion (2018 release) Update 5.
Parameters
|
|
Required/Optional |
Description |
|---|---|---|
|
query |
Required |
Query in which at least one value is to be searched. |
|
closure |
Required |
Function that encapsulates criteria. |
|
parallel |
Optional |
True if you want to enable parallel programming. |
|
maxThreadCount |
Optional |
The number of threads the function can execute. The number of threads must be between 1-50. If the value exceeds 50, there is an exception. |
Example
<cfscript>
myQuery=queryNew([
{"Id":101,"Name":"John"},
{"Id":102,"Name":"Jason"},
{"Id":103,"Name":"Jack"},
{"Id":104,"Name":"James"}
]);
// First closure to check for Jim
doesPersonExist=(obj)=>return obj.name=="Jim"
writeOutput(QuerySome(myquery,doesPersonExist)) // Returns False
// Second closure to check for James
doesPersonExist=(obj)=>return obj.name=="James"
writeOutput("<br/>" & QuerySome(myquery,doesPersonExist)) // Returns True
</cfscript>
Output
NO
YES
Using parallelization
<cfscript>
myQuery=queryNew([
{"Id":101,"Name":"John"},
{"Id":102,"Name":"Jason"},
{"Id":103,"Name":"Jack"},
{"Id":104,"Name":"James"}
]);
// First closure to check for Jim
doesPersonExist=(obj)=>return obj.name=="Jim"
writeOutput(QuerySome(myquery,doesPersonExist)) // Returns False
// Second closure to check for James
doesPersonExist=(obj)=>return obj.name=="James"
writeOutput("" & QuerySome(myquery,doesPersonExist,true,5)) // Returns True
</cfscript>
Adobe MAX
The Creativity Conference
Oct 14–16 Miami Beach and online
Adobe MAX
The Creativity Conference
Oct 14–16 Miami Beach and online