TryCF Gist

trycf-gist-1752035595227-e7d10819-52de-89b3-1a06-5b5771d5bb52.cfm

<cfscript>
    // Original in-memory query
    employees = queryNew(
        "id,name,dept,salary",
        "CF_SQL_INTEGER,CF_SQL_VARCHAR,CF_SQL_VARCHAR,CF_SQL_INTEGER",
        [
            { id: 1, name: "Alice", dept: "IT", salary: 50000 },
            { id: 2, name: "Bob", dept: "HR", salary: 45000 },
            { id: 3, name: "Carol", dept: "IT", salary: 52000 },
            { id: 4, name: "Dan", dept: "Finance", salary: 47000 }
        ]
    );

    // Query of Query: Filter only IT department
    itEmployees = queryExecute(
        "SELECT * FROM employees WHERE dept = 'IT'",
        [],
        { dbtype = "query"}
    );

    // Output the filtered result
    writeDump(itEmployees);
</cfscript>