viewcont.html if(request.log) { redirect("comframe.html?contactid=" + request.id); } dbconnect(); contact = database.cursor("SELECT * FROM contacts WHERE contactid = " + request.id) company = database.cursor("SELECT * FROM companies ORDER BY companyname") //Performs an update on the contact information if the user clicks update. if(request.up) { database.execute("UPDATE contacts SET Firstname='" + request.firstname + "', lastname='" + request.lastname + "', dear='" + request.dear + "', companyname='" + request.companyname + "', address='" + request.address + "', city='" + request.city + "', stateorprovince='" + request.stateorprovince + "', postalcode='" + request.postalcode + "', country='" + request.country + "', title='" + request.title + "', workphone='" + request.workphone + "', workextension='" + request.workextension + "', faxNumber='" + request.faxnumber + "', homePhone='" + request.homephone + "', pager='" + request.pager + "', mobilePhone='" + request.mobilephone + "', emailname='" + request.emailname + "', lastmeetingdate='" + request.lastmeetingdate + "', contacttypeid='" + request.contacttypeid + "', referredby='" + request.referredby + "', notes='" + request.notes + "' WHERE contactid = " + request.id) redirect("contact.html"); } //Performs a delete if the user clicks delete. if(request.del) { database.execute("DELETE FROM contacts WHERE contactid =" + request.id) redirect("contact.html") } ")
if(client.search1) { write("
") } if(client.search2) { write("") } write("") write("

客戶資料查詢/維護
//Outputs detailed contact info. if(contact.next()) { write("") write("") write("") write("") write("") write("") write("") write("") write("") write("") write("") write("") write("") write("") write("") write("") write("") write("") write("") write("") write("
中文姓名*英文姓名*
職稱外號
公司名稱
工作地址
區域號碼公司英文名稱
家中地址生日
工作電話工作電話分機
家中電話呼叫器
行動電話傳真號碼
電子郵件
介紹人客戶類別
最後聯絡日期
備註
") write("") }

* 表示為必須輸入之欄位