viewcomm.html 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("" + contact.firstname + " " + contact.lastname + " 的業務往來資料維護
") } write("") write("") write("") write("
聯絡日期*(例如 8/7/96)
聯絡時間
主題
備註
") write("") write("")
* 表示為必須輸入之欄位