queryTest.cfm

<cfscript>
    /* Put this in the Setup Tab */
    myTable = queryNew("fruit,color","Integer,Varchar",[ ["apples","green"], ["banannas","yellow"], ["grapes","purple"] ]);
    /****************************/
    
    /* Put this in the Default Tab */
    writeDump(myTable);
    
    local.svc = new query(
        sql = "SELECT * FROM myTable",
        dbtype = "query",
        myTable = myTable
    );
    
    local.obj = local.svc.execute();
    
    writeDump(local.obj);
    writeDump(local.obj.getPrefix());
    writeDump(local.obj.getResult());
    
</cfscript>