TryCF Gist

trycf-gist-1641380062636-745c6ce1-e5f8-f421-b015-450185b2aa7d.cfm

<cfscript>
employees = queryNew( 'name,age,email', 'varchar,integer,varchar');

    try {
        actual = QueryExecute(
    		sql = "SELECT name, age, name from employees ORDER BY age, email",
    		options = { dbtype: 'query' }
    	); // Reading twice the column (name) in SELECT statement and order by column which is not in SELECT statement (email)
    
        writedump( actual )
    }
    catch (any e) {
        writedump( e.message );
        writedump( e.type );
    }
</cfscript>