query.every()

edit

This function calls a given closure/function with every element in a given query and returns true, if all of the closure calls returns true.

query.every( closure=function, parallel=boolean, maxThreads=number )

Returns: Boolean

Argument Description
closure
function, required 		edit

function/closure that implements the following constructor

function(struct row [number rownumber, query query]) { returns boolean; ).

Alias: function, callback, udf
parallel
boolean, optional 		edit

execute closures parallel
maxThreads
number, optional 		edit

maximum number of threads executed

ignored when argument "parallel" is set to false

Alias: maxThreadCount

Examples

edit 
	people = QueryNew( "name,dob,age", "varchar,date,int", [
		[ "Susi", CreateDate( 1970, 1, 1 ), 0 ],
		[ "Urs" , CreateDate( 1995, 1, 1 ), 0 ],
		[ "Fred", CreateDate( 1960, 1, 1 ), 0 ],
		[ "Jim" , CreateDate( 1988, 1, 1 ), 0 ]
	]);
	valid = people.Every(function(row, rowNumber, qryData){
	    return ((DateDiff('yyyy', row.dob, Now()) > 0) && (DateDiff('yyyy', row.dob, Now()) <= 100))
	});
	writeDump(valid);

See also