// Check to see if the 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)
{
// Change the class info
database.execute("update cl_master set " +
"c_stitle = '" + sqlescape(request.stitle) + "'," +
"c_title = '" + sqlescape(request.title) + "'," +
"c_desc = '" + sqlescape(request.desc) + "'," +
"c_int_ext = '" +
((request.int_ext == "internal") ? "I" : "E") + "'," +
"c_cost = " + request.cost + "," +
"c_prereq = '" + sqlescape(request.prereq) + "'," +
"c_elig = '" + sqlescape(request.elig) + "'," +
"c_location = '" + sqlescape(request.location) + "'," +
"c_mgr = " + request.mgr + "," +
"c_email_ind = '" +
((request.email_ind == "cmgr") ? "C" : "S") + "'," +
"c_closed = '" +
((request.closed == "on") ? "Y" : "N") + "' " +
"where c_id = " + request.id);
redirect("mae-feedback.htm");
}
else
// Bad manager id
redirect("ma-badmgr.htm");