Due Date: November 20, 2000

(1)    Write an ASP program to allow searching for faculty directory information.  The basic table to search against should be stored in Access and contains at least the following contents:
 

f00h8

Program	LastName	FirstName	URL	Id
Computer Science	Yue	Bun	http://nas.uhcl.edu/yue	1
Software Engineering	White	Sharon	http://nas.uhcl.edu/white	2
Software Engineering	Helm	Jim	http://nas.uhcl.edu/helm	3
Computer Information Systems	Hall	Sharon	http://nas.uhcl.edu/perkins	4
Computer Information Systems	Liaw	Morris	http://nas.uhcl.edu/liaw	5
Biology	Mills	Ronald	http://nas.uhcl.edu/mills	6
Biology	Lu	Jack	http://nas.uhcl.edu/lu	7
Computer Science	Davari	Sadegh	http://nas.uhcl.edu/davari	8
Computer Science	Feagin	Terry	http://nas.uhcl.edu/feagin	9
Chemistry	Sanchez	Ramiro	http://nas.uhcl.edu/sanchez	10
Mathematics	Shiau	LieJune	http://nas.uhcl.edu/shiau	11
Mathematics	Mezzino	Michael	http://nas.uhcl.edu/mezzino	12
Computer Science	Giarrantano	Joseph	http://nas.uhcl.edu/giarratano	13
Computer Engineering	Harman	Thomas	http://nas.uhcl.edu/harman	14

Initially, the program displays a welcome page with a search form.  The page allows three ways for searching the faculty directory.

The first method for searching is to enter a substring of the last name of the faculty member.  For example, if the substring "li" is entered, the page should respond with the following screen:

Note that in the result page, Morris Liaw is a link to his URL.

The second method is to click on one of the available links from 'A' to 'Z', which is the first character of the faculty last name.  For example, if the link H is clicked, the following should be displayed.  Note that the result is sorted in the order of the last name.

The last method is to select the program option to list all faculty in the program.  The search form should has all programs included in the options.  For example, if "Computer Science" is selected, the following page should be displayed.

You should write your program to generate output as close to the output above as possible.  Note that the search form appears in every page.

Bonus:

1. (5 points)  In the select program method, include an 'ALL' option that lists faculty members of all programs, sorted in program orders.

2.  (10 points)  Modify the program so that the for the first character of the last name, a link appears only if it has result.  For example, if there is no faculty member with a last name that starts with x, then X should be display simply as X, and not a link.

3. (30 points)  Change the table to add more rows to this part for testing.  In the display result page, display only up to ten records and add links "prev", "next", 1, 2, 3, 4, etc, to navigate through individual result page in an efficient manner.  For example, if there are 35 faculty members with last names starting with "L", then the results are listed in four pages.