QueryOfqueryrun()

Executes a Query-of-Query against a previous SQL result sets. Function version of CFQUERY

QUERY = QueryOfqueryrun(
				
					
					
						sql, 
					
				
					
					
						params
					
				
				)

Argument	Summary
sql	SQL string
params	array of structures {value, padding, scale, maxlength, separator, list, defaultlist, nullvalue, cfsqltype} representing the attributes of CFQUERYPARAM; one for each ? within the SQL string [optional]

Supports named-parameter calling allowing you to use the function like:

QueryOfqueryrun(
   sql=?, 
   params=?
);

Supports passing parameters as a structure using ArgumentCollection:

QueryOfqueryrun( ArgumentCollection={
   sql : ?, 
   params : ?
} );

See QueryRun() for an example of how to use dynamic parameters.