repcont.html if(request.search1 || request.search2) { dbconnect(); if(request.search1) { //if they search using the textbox 中文姓名=first name contact = database.cursor("SELECT * FROM contacts WHERE firstname LIKE '%" + request.search1 + "%' ORDER BY firstname") } if(request.search2) { if(request.search2 == "all") { //Select all the contacts, no search criteria contact = database.cursor("SELECT * FROM contacts ORDER BY lastname") } else { //Select all contacts where the last name starts with the letter chosen. var lowcaps = request.search2.toLowerCase() contact = database.cursor("SELECT * FROM contacts WHERE lastname LIKE '" + request.search2 + "%' OR lastname LIKE '" + lowcaps + "%' ORDER BY firstname") } } }

客戶往來記錄表

客戶查詢
1.中文姓名含: if(request.search1 == null) { write("") } else { //displays what was previously searched write("") }
write("2.顯示全部資料")

3.英文姓名起始字母:

write("A") write("B") write("C") write("D") write("E") write("F") write("G") write("H") write("I") write("J") write("K") write("L") write("M") write("N") write("O") write("P") write("Q") write("R") write("S") write("T") write("U") write("V") write("W") write("X") write("Y") write("Z")
if(request.search1) { write("客戶資料中姓名含 : " + request.search1 + "") } if(request.search2) { if(request.search2 == "all") { write("顯示所有客戶資料") } else { write("客戶英文姓名中以 : " + request.search2 + "起頭
") } } if(contact.next()) { if(request.search1 || request.search2) { write("

請選擇客戶及聯絡日期以產生報表.") write("") write("") write("") write("
客戶姓名 聯絡日期在下列天數內
") write(" ") write("") write("
") write("
聯絡日期在
之間的資料") write("
(格式為 9/12/96 至 9/24/96)
") } }else { write("

無符合客戶資料.") }