TaskProject/views/faculty.cfc

component {

    // Function to read all students
    function getAllStudents() {
        var students = [];
        // Define the query
        var allQuery = new query(datasource="task");
        allQuery.setSQL("SELECT * FROM student");
        
        // Execute the query
        var result = allQuery.execute();
        
        // Check if the query executed successfully
        if (isQuery(result)) {
            // Loop through the query result
            while (result.next()) {
                var student = {
                    "sid": result.sid,
                    "sname": result.sname,
                    "major": result.major,
                    "level": result.level,
                    "byear": result.byear
                };
                // Append the student to the students array
                arrayAppend(students, student);
            }
            // Close the query result
            result.close();
        } else {
            // Log an error or handle the case when the query execution fails
             writeLog(file="application", text="Failed to execute query: #allQuery.getSql()#");
        }
        
        // Return the array of students
        return students;
    }
}