contact.html
if(request.search1 || request.search2) {
dbconnect();
if(request.search1) {
//if they search using the textbox
contact = database.cursor("SELECT * FROM contacts WHERE firstname LIKE '%" + request.search1 + "%' ORDER BY firstname")
client.search1 = request.search1
}
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")
}
client.search2 = request.search2
}
}
客戶資料查詢
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 + "起首
")
}
}
while(contact.next()) {
//list of all the contacts returned by the search.
write("
" + contact.lastname + ", " + contact.firstname + "
")
}