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