Class Roster
cursor = database.cursor("select * from cl_enroll where e_id = " + request.id); cursor.next(); // Update the enrollment record now = new Date(); database.execute("update cl_enroll set " + "e_appr_deny = 'D'," + "e_appr_reason = '" + sqlescape(request.reason) + "'," + "e_appr_by = " + client.uid + "," + "e_appr_dt = '" + dbdate(now) + "' " + "where e_id = " + request.id); // Generate an 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 denied enrollment in the class " + trim(clcursor.c_title) + " for the reason " + request.reason; write("A message has been generated denying enrollment in
" + trim(clcursor.c_title) + "
"); write("Please click "Send Mail" to send it to " + tomail + " and then click continue to move on.
");
user.close(); student.close(); clcursor.close(); cursor.close();