dbconnect();
comm = database.cursor("SELECT * FROM calls WHERE callid = " + request.callid)
if(comm.next()) {
contact = database.cursor("SELECT firstname,lastname FROM contacts WHERE contactid=" + comm.contactid)
}
if(request.up) {
database.execute("UPDATE calls SET calldate = '" +
request.calldate + "', calltime = '" +
request.calltime + "', subject = '" +
request.subject + "', notes = '" +
request.notes + "' WHERE callid = " + request.callid)
redirect("comlog.html?contactid=" + request.contactid);
}
if(request.del) {
database.execute("DELETE FROM Calls WHERE callid = " + request.callid)
redirect("comlog.html?contactid=" + request.contactid);
}