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); }


if(contact.next()) { write("Edit Log Entry for " + contact.firstname + " " + contact.lastname + "
") } write("") write("") write("") write("
Date*(e.g. 8/7/96)
Time
Subject
Notes
") write("") write("")
* Required Field