<!--- Start out by creating a query object. ---> <cfset qOuter = QueryNew( "" ) /> <!--- Add a column and set default values. ---> <cfset QueryAddColumn( qOuter, "id", "INTEGER", ListToArray( "1,2,3,4,5" ) ) /> <!--- Get a reference to the outter query, just for testing purposes. Since we are nesting queries, we want an outter reference to take away scope issues. This this is a query, it is passed by reference (not value). ---> <cfset qOuterRef = qOuter />