QuerySome

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

Parameter

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

Get help faster and easier

New user?