// Get the class info clcursor = database.cursor("select * from cl_master where c_id = " + request.id); clcursor.next();

Class Roster for write(trim(clcursor.c_title));

// A little helpful reminder write("

Location: " + trim(clcursor.c_location) + "

");
// Display the class timings cursor = database.cursor("select * from cl_times where c_id = " + request.id); while (cursor.next()) { write(""); write(""); write(""); write(""); write(""); } cursor.close();
Date Start Time Stop Time
" + dbdate(cursor.t_dt) + "" + cursor.t_start + "" + cursor.t_stop + "
// Display the enrollment roster for this class cursor = database.cursor("select * from cl_enroll where c_id = " + request.id); while (cursor.next()) { write(""); // Get the student's name student = database.cursor("select * from cl_person where " + "p_id = " + cursor.e_student); student.next(); write(""); student.close(); // Get the student's manager's name mgr = database.cursor("select * from cl_person where " + "p_id = " + cursor.e_manager); mgr.next(); write(""); mgr.close(); // Date of enroll request write(""); // Fill in the current approval/denial/unknown status apprcheck = ""; denycheck = ""; if (cursor.e_appr_deny == "A") apprcheck = " checked"; else if (cursor.e_appr_deny == "D") denycheck = " checked"; write(""); write(""); write(""); }
Student Student's Manager Request Date Approve Deny
" + trim(student.p_name) + "" + trim(mgr.p_name) + "" + dbdate(cursor.e_request_dt) + "