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