Whatever message this page gives is out now! Go check it out!
QueryEvery
Last update:
May 18, 2026
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 all values of a query satisfy a given condition.
Returns
True if all values match a condition; false, otherwise.
Syntax
queryEvery(query, closure [, parallel] [, maxThreadCount])Member function
queryObj.Every(closure)History
ColdFusion (2021 release): Introduced the following parameters:
- parallel
- maxThreadCount
New in ColdFusion (2018 release) Update 5.
Parameters
Parameter | Required/Optional | Description |
struct | Required | Query in which all values are 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
Example 1
<cfscript>
myQuery=queryNew([
{"Id":101,"Name":"John Adams","Contract":"Permanent"},
{"Id":102,"Name":"Jason Adams","Contract":"Temp"},
{"Id":103,"Name":"Jack Adams","Contract":"Temp"},
{"Id":104,"Name":"James Adams","Contract":"Permanent"}
]);
doesPersonExist=(obj)=>return obj.contract=="Permanent"
writeOutput(QueryEvery(myquery,doesPersonExist)) // Returns False
</cfscript>Output
NO
Example 2
<cfscript>
myQuery=queryNew([
{"Id":101,"Name":"John Adams","Contract":"Permanent"},
{"Id":102,"Name":"Jason Adams","Contract":"Permanent"},
{"Id":103,"Name":"Jack Adams","Contract":"Permanent"},
{"Id":104,"Name":"James Adams","Contract":"Permanent"}
]);
doesPersonExist=(obj)=>return obj.contract=="Permanent"
writeOutput(QueryEvery(myquery,doesPersonExist)) // Returns True
</cfscript>Output
YES
Using parallelization
<cfscript>
myQuery=queryNew([
{"Id":101,"Name":"John Adams","Contract":"Permanent"},
{"Id":102,"Name":"Jason Adams","Contract":"Permanent"},
{"Id":103,"Name":"Jack Adams","Contract":"Permanent"},
{"Id":104,"Name":"James Adams","Contract":"Permanent"}
]);
doesPersonExist=(obj)=>return obj.contract=="Permanent"
writeOutput(QueryEvery(myquery,doesPersonExist,true,5)) // Returns True
</cfscript>
We're glad. Tell us how this page helped.
We're sorry. Can you tell us what didn't work for you?
Share additional feedback to help us improve.
0/255
|
