Skip to content

Instantly share code, notes, and snippets.

View phantom42's full-sized avatar

Erik Coleman phantom42

View GitHub Profile
@phantom42
phantom42 / cfscript qoq
Created December 12, 2012 14:22
the basic setup of a cfscript version of a query of queries.
// cfscript method of a query of queries
// there seems to be no supported way to create a qoq using the more common queryNew() cfscript
local.qoqObj = new Query(dbtype='query', sql="select * from qrySource where [sql conditional] ") ; // qrySource is an attribute set below
local.qoqObj.setAttributes(qrySource=local.actualSourceQuery) ; //
local.qryQoqResults = local.qoqObj.execute().getResult() ;