dbconnect(); actionitems = database.cursor("SELECT * FROM ActionItems WHERE projectname = '" + unescape(request.projectname) + "' AND closedate IS null")

Open Action Items Report

write("Project Name : " + unescape(request.projectname) + "
") if(actionitems.next()) { write("") write("") write("") write("") write("") write("
Action Item:"+ actionitems.actionitem + "
Requester: " + actionitems.requester + "Owner: " + actionitems.owner +"
") write("
Due:" + datetoString(actionitems.duedate) + "Open:" + datetoString(actionitems.opendate) +"

") while(actionitems.next()) { write("") write("") write("") write("") write("") write("
Action Item:"+ actionitems.actionitem + "
Requester: " + actionitems.requester + "Owner: " + actionitems.owner +"
") write("
Due:" + datetoString(actionitems.duedate) + "Open:" + datetoString(actionitems.opendate) +"

") } }else { write("
This project has no open action items.") }