TryCF Gist

trycf-gist-1641543465098-9b942be1-dab1-ddeb-c0c2-60e84f0d4b3b.cfm

<cfscript>
    employees = queryNew( 'name,age,email'
        , 'varchar,integer,varchar'
        ,[
            [ 'John Doe',28,'John@company.com' ],
            [ 'Jane Doe',22,'Jane@company.com' ],
            [ 'Bane Doe',28,'Bane@company.com' ]
        ] 
    );
    writeDump(employees);
</cfscript>
<cftry>
    <!--commented line -- , email in select statement -->
    <cfquery name="test" dbtype="query">
        select age
        -- ,email
    	from employees
        order by age;
    </cfquery>
    <cfdump var="#test#">
    <cfcatch>
        <cfdump var="#cfcatch.message#">
    </cfcatch>
</cftry>

<cftry>
    <!--commented line -- , email in ORDER By -->
    <cfquery name="test" dbtype="query">
        select age
    	from employees
        order by age -- ,email;
    </cfquery>
    <cfdump var="#test#">
    <cfcatch>
        <cfdump var="#cfcatch.message#">
    </cfcatch>
</cftry>