var CustNameString = "" // build a string for customer number href to summaryr
project.lock()
CustNameCursor = database.cursor("select * from customer where customer_name like '" + request.CustName + "%' order by customer_name")
if (request.CustName.length > 0)
write ("Customer Names that begin with " + request.CustName + ".
")
else
write ("All available customers by name.
")
write ("")
write ("" +
"Customer number | " +
"Name | " +
"
")
while (CustNameCursor.next()) {
write(CustNameCursor.customer_no);
|
write("" + CustNameCursor.customer_name + " | " +
"")
} //end while
write ("
")
project.unlock()