Query of a Query in ColdFusion script with the local scope

I don't do alot of Query of Queries and when I do I often forget that you can escape special reserved words. One of those words is local.

With ColdFusion 9's local scope this is likely to come up if you name the first query local.someQuery and try to QoQ that it wont work unless you escape local as so:

[local].someQuery

We had to do this anyway as we always used to do:

< cfset var local = {} /> prior to CF9.

While making an example I wanted to write this in tags and in pure script. QoQ in script proved a challenge I thought it would just work but it actually needs an additional line:

local.qoq.setAttributes(resultSet = local.qryRes.getResult());

where local.qoq is the new query object and local.qryRes is the original query.

I tried for a while and knew I had seen this in action once but I could not work it out. I had a quick chat with Dave Ferguson who pointed me in the right direction.

Here is an example:

Click here to run the code.

Tag implementation.<br /> <cfset tempObject1= createObject("component","qSample").init() /><br /> ---------------------<br /> Script Implementation.<br /> <cfscript><br /> tempObject2 = new scriptQSample();<br /> </cfscript>

Tag based cfc:

<br /> <cfcomponent output="true"><br /> <br /> <cffunction name="init" returntype="qSample"><br /> <cfset someFunction() /><br /> <br /> <cfreturn this/><br /> </cffunction><br /> <br /> <cffunction name="someFunction" returntype="void"><br /> <cfquery name="local.fullQuery" datasource="test"><br /> select id, firstName, lastName, age<br /> from testData<br /> </cfquery><br /> <br /> <cfdump var="#local.fullQuery#" /><br /> <br /> <cfquery name="local.qoq" dbtype="query"><br /> select id, firstName, lastName, age<br /> from [local].fullQuery<br /> where age > 30<br /> </cfquery><br /> <br /> <cfdump var="#local.qoq#" /><br /> </cffunction><br /> <br /> </cfcomponent><br />

Script based cfc:

<br /> component{<br /> <br /> public scriptQSample function init(){<br /> someFunction();<br /> <br /> return this;<br /> }<br /> <br /> private void function someFunction(){<br /> local.queryString = "select id, firstName, lastName, age<br /> from testData";<br /> local.fullQuery= new Query();<br /> local.fullQuery.setDataSource("test");<br /> local.fullQuery.setSQL(#local.queryString#);<br /> local.qryRes = local.fullQuery.execute();<br /> writedump(local.qryRes.getResult());<br /> <br /> local.queryString = "select id, firstName, lastName, age<br /> from resultSet<br /> where age > 30";<br /> <br /> local.qoq = new Query();<br /> local.qoq.setAttributes(resultSet = local.qryRes.getResult());<br /> local.qoq.SetDBType("query");<br /> local.qoqResult = local.qoq.execute(sql=local.queryString); <br /> writedump(local.qoqResult.getResult());<br /> }<br /> <br /> <br /> }<br />