addcont.html dbconnect(); company = database.cursor("SELECT * FROM companies ORDER BY companyname") if(request.fillin) { // This cursor retrieves company info to help // fill in some of the contact information if requested. compinfo = database.cursor("SELECT * FROM companies WHERE companyname = '" + request.companyname + "'") } else { if(request.firstname && request.lastname) { // inserts the contact information into the Contacts table. database.execute("INSERT INTO contacts (firstname, lastname, dear, companyname," + " address, city, stateorprovince, postalcode, country, title," + " workphone, workextension, faxnumber, homephone, pager, " + " mobilephone, emailname, lastmeetingdate, contacttypeid," + " referredby, notes) " + " VALUES ('" + request.firstname + "','" + request.lastname + "','" + request.dear + "','" + request.companyname + "','" + request.address + "','" + request.city + "','" + request.stateorprovince + "','" + request.postalcode + "','" + request.country + "','" + request.title + "', '" + request.workphone + "','" + request.workextension + "','" + request.faxnumber + "','" + request.homephone + "','" + request.pager + "','" + request.mobilephone + "','" + request.emailname + "','" + request.lastmeetingdate + "','" + request.contacttypeid + "','" + request.referredby + "','" + request.notes + "')"); redirect("contact.html?newsearch=contact"); } }

新增客戶資料
if(request.fillin) { // This section of code is executed when the 'Use Defaults' // button is clicked. write("") write("") write("") write("") if(compinfo.next()) { // company information is outputted here for the company chosen. write("") write("") write("") write("") //write("") write("") write("") write("") } } else { // This is the form used to add a contact. There is a button // that lets you use company information as default to fill in basic // contact information. When the 'Use Defaults' button is clicked, the // if section of this if/else statement is executed. write("") write("") write("") write("") write("") write("") write("") write("") write("") write("") write("") write("") write("") write("") }
中文姓名*:英文姓名*:
外號:職稱:
公司名稱:
聯絡地址:
區域號碼:家中地址:
統一編號:公司英文名稱:
工作電話:中文姓名*:英文姓名*:
外號:職稱:
公司名稱:
工作地址:
區域號碼:家中地址:
生日:公司英文名稱:
工作電話: 工作電話分機:
家中電話: 行動電話:
傳真電話: 呼叫器:
電子郵件:
客戶類別: 最後聯絡日期:
介紹人:
備註:

* 表示為必須輸入之欄位