[Coldbox 4.3.0][Coldfusion 11]Query Of Queries runtime error. Table named programmes was not found

[echo]

Hi, I am writing a function in model service, doing query of queries. The code is as followed:

      public function getProgramBu(programmes){

writedump(programmes);

var temp=programmes_busService.executeQuery("from programmes_bus");

var q= new query();

q.setName("myQuery");

q.setDBType("query");

q.setAttributes(sourceQuery=programmes);

var result= q.execute(sql = "select * from programmes, temp where temp.programme_id = programmes.id").getresult();

writedump(result);

abort;

}

 when I dump the programmes which is passed in as a parameter, the correct query shows. Temp as well. However, when it goes to execute sql. The error is

 Query Of Queries runtime error. 

Table named programmes was not found in memory. The name is misspelled or the table is not defined.

I wonder what is wrong. Thanks a lot for your help.

Icy

[Ancient Programmer]

You might get the same error as this: https://christierney.com/2011/02/22/coldfusion-9-query-of-query-in-cfscript/

Change the query to this:

var result= q.execute(sql = "select * from sourceQuery, temp where temp.programme_id = sourceQuery.id").getresult();

[echo]

Thankssssss. It works^^ (I had some misunderstanding on setAttributes before)

Thanks again~