if(request.changeproj) {
redirect("project.html")
}
if(request.addproj) {
redirect("newproj.html")
}
if(request.updateproject) {
//updates the project information
redirect("project.html");
}
dbconnect();
projects = database.cursor("SELECT * FROM Project ORDER BY ProjectName")
if(request.all) {
//searches for open and closed action items
actionitems = database.cursor("SELECT * FROM ActionItems WHERE projectname = '" + request.project + "' ORDER BY closedate")
}
else {
//searches for open action items only
actionitems = database.cursor("SELECT * FROM ActionItems WHERE projectname = '" + request.project + "' AND closedate IS Null")
}