dbconnect(); actionitem = database.cursor("SELECT * FROM ActionItems WHERE actionID = " + request.actionID) if(actionitem.next()) { if(request.close) { var mydate = new Date() database.execute("UPDATE actionitems SET closedate = '" + datetoString(mydate) + "' WHERE actionid = " + request.actionID) redirect("projact.html?project=" + escape(actionitem.projectname)) } } if(request.up) { database.execute("UPDATE actionitems SET Actionitem = '" + request.actionitem + "', Requester = '" + request.requester + "', Owner = '" + request.owner + "', Opendate = '" + request.opendate + "', Duedate = '" + request.duedate + "', Closedate = '" + request.closedate + "' WHERE actionid = " + request.actionID) redirect("projact.html?project=" + escape(actionitem.projectname)) } if(request.del) { database.execute("DELETE FROM actionitems WHERE actionid = " + request.actionID) redirect("projact.html?project=" + escape(actionitem.projectname)) } if(request.changeproj) { redirect("project.html"); }
Edit Action Item
/* This page dynamically outputs the information of an action item generated when the user clicks on the edit button in projact.html. The user can now change any information needed and click on the update button which directs them to this same page and performs the update function. */ write("
Action Item
Description
") write("
" + actionitem.actionitem + "
") write("
Requester
") write("
Owner
") write("
Open Date
(e.g. 8/7/96)
") write("
Due Date
(e.g. 8/10/96)
") write("
Close Date
(e.g. 8/9/96)
") write("
") while(actionitem.next()) { write("
Action Item
Description
") write("
" + actionitem.actionitem + "
") write("
Requester
") write("
Owner
") write("
Open Date
(e.g. 8/7/96)
") write("
Due Date
(e.g. 8/10/96)
") write("
Close Date
(e.g. 8/9/96)
") write("
") }