if(request.search1 || request.search2) {
dbconnect();
if(request.search1) {
//if they search using the textbox
contact = database.cursor("SELECT * FROM contacts WHERE lastname 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
}
}
Contact Search
case sensitive
Last Name begins with:
write("List All")
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("Contacts whose Last Name contains " + request.search1 + "
")
}
if(request.search2) {
if(request.search2 == "all") {
write("List of all contacts
")
}
else {
write("Contacts whose Last Name begins with the letter " + request.search2 + "
")
}
}
while(contact.next()) {
//list of all the contacts returned by the search.
write("
" + contact.lastname + ", " + contact.firstname + "
")
}