Skip to content

Instantly share code, notes, and snippets.

@phantom42

phantom42/cfscript qoq

Created December 12, 2012 14:22
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save phantom42/4268074 to your computer and use it in GitHub Desktop.
Save phantom42/4268074 to your computer and use it in GitHub Desktop.
Download ZIP
the basic setup of a cfscript version of a query of queries.
Raw
cfscript qoq
// 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() ;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment