cfscript query of queries not working with where clause

Hi @muncho62 ,

Could you please give us some feedback. It will help others having a similar issue.

Your title, "cfscript query of queries not working with where clause", is of the kind that will certainly receive hits in future. 

How did things turn out?

1. Give function a name;

2. Use QueryExecute() instead. It is faster than Query(), and has simpler code:

function getQueryOfQuery(query orgData){

	var sqlParams = {};
	var sqlString = "SELECT distinct aoi FROM sourceQuery where region = :region";
	
	sqlParams.region = {value="midwest", cfsqltype="varchar"};
	
	var newOrgData = queryExecute(sqlString, sqlParams, {dbType="query"});
	
	return newOrgData;
}

I created the follow sample script to run your code and it works as expected for me. Are you seeing any particular error?

<cfscript>
mq = queryNew("aoi,region","Integer,Varchar", 
[ 
{aoi=1,region="southeast"}, 
{aoi=2,region="northeast"}, 
{aoi=3,region="midwest"} 
]);	

runQuery(mq);
	
function runQuery(query orgData){
adminUsersQuery = new Query();
adminUsersQuery.setDBType('query');
adminUsersQuery.setAttributes(sourceQuery=orgData);
adminUsersQuery.addParam(name='region', value='midwest', cfsqltype='cf_sql_varchar');
adminUsersQuery.setSQL("SELECT distinct aoi FROM sourceQuery where region = :region");
newOrgData = adminUsersQuery.execute().getResult();

writeDump(newOrgData);
}
</cfscript>