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 } }
if(request.newsearch) { write("") }
Contact Search
case sensitive
Last Name contains: if(request.search1 == null) { write("") } else { write("") }
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("Bullet " + contact.lastname + ", " + contact.firstname + "
") }