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