QueryEvery

QueryEvery

Išči

某些 Creative Cloud 应用程序、服务和功能在中国不可用。

Description

Determines if all values of a query satisfy a given condition.

Returns

True if all values match a condition; false, otherwise.

Syntax

1
QueryEvery(query,closure)

Member function

1
queryObj.Every(closure)

History

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.

Example

Example 1

1
2
3
4
5
6
7
8
9
10
<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

1
2
3
4
5
6
7
8
9
10
<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