
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();