Class Roster
// Get the enrollment roster for this class cursor = database.cursor("select * from cl_enroll where e_id = " + request.id); cursor.next(); // Check to see if already been aprroved (no sense doing it again> if (cursor.e_appr_deny == "A") { c_id = cursor.c_id; cursor.close(); redirect("ma-roster.htm?id=" + c_id); } // Insert the enrollment record now = new Date(); database.execute("update cl_enroll set " + "e_appr_deny = 'A'," + "e_appr_by = " + client.uid + "," + "e_appr_dt = '" + dbdate(now) + "' " + "where e_id = " + request.id); // Generate e-mail message clcursor = database.cursor("select * from cl_master where c_id = " + cursor.c_id); clcursor.next(); student = database.cursor("select * from cl_person where p_id = " + cursor.e_student); student.next(); tomail = trim(student.p_email); msg = "You have been approved for enrollment in the class " + trim(clcursor.c_title); write("A message has been generated approving enrollment in
" + trim(clcursor.c_title) + "
"); write("Please click "Send Mail" to send it to " + tomail + " and then click continue to move on.
");
student.close(); clcursor.close(); cursor.close();