// Check to see if the given course manager exists
cursor = database.cursor("select * from cl_person where p_id = " +
request.mgr);
if (cursor.next() == false)
badmgr = true;
else
badmgr = false;
cursor.close();
if (!badmgr)
{
// Insert in the new class
database.execute("insert into cl_master values(" +
request.id + ",'" +
sqlescape(request.stitle) + "','" +
sqlescape(request.title) + "','" +
sqlescape(request.desc) + "','" +
((request.int_ext == "internal") ? "I" : "E") + "'," +
request.cost + ",'" +
sqlescape(request.prereq) + "','" +
sqlescape(request.elig) + "','" +
sqlescape(request.location) + "'," +
request.mgr + ",'" +
((request.email_ind == "cmgr") ? "C" : "S") + "','" +
((request.closed == "on") ? "Y" : "N") + "')");
// Time to edit the class timings
redirect("maec-frame.htm?id=" + request.id);
}
else
// The course manager id was not valid
redirect("ma-badmgr.htm");