// Check for an invalid manager id 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) // Try again redirect("ma-badmgr.htm");
Request Received // Find a unique id project.lock(); if (project.nextEnrollID == null) // Property doesn't exist, do a database lookup project.nextEnrollID = getNewID("cl_enroll", "e_id"); else // Increment the previous value project.nextEnrollID = 1 + parseInt(project.nextEnrollID); project.unlock(); // Get the class info cursor = database.cursor("select * from cl_master where c_id = " + request.id); cursor.next(); // Get the course manager's info cmgr = database.cursor("select * from cl_person where p_id = " + cursor.c_mgr); cmgr.next(); // Get the student manager's info smgr = database.cursor("select * from cl_person where p_id = " + request.mgr); smgr.next(); // Get the user's info user = database.cursor("select * from cl_person where p_id = " + client.uid); user.next(); // Figure out who the send the request to (course or student manager) if (cursor.c_email_ind == "C") { tomail = cmgr.p_email; toname = cmgr.p_name; } else { tomail = smgr.p_email; toname = smgr.p_name; } tomail = trim(tomail); toname = trim(toname); // Update the enrollment table now = new Date(); database.execute("insert into cl_enroll values(" + cursor.c_id + "," + project.nextEnrollID + "," + client.uid + "," + smgr.p_id + ",'" + dbdate(now) + "',null,null,null,null)"); // Craft a short message for e-mail msg = trim(user.p_name) + " would like to enroll in " + trim(cursor.c_title); // Generate a prompt write("A message has been generated asking for
" + trim(cursor.c_title) + "
"); write("Please click "Send Mail" to send it to " + tomail + "
");
user.close(); smgr.close(); cmgr.close(); cursor.close();