Databases Reference
In-Depth Information
Client
Server
Browse
IDC
SQL
Updates
Results
HTX
HTML
formatted results
template
Results
Database
Exhibit 35-1. IDC operation.
• Store first name, last name, and telephone number of multiple individ-
uals.
• Allow the user to search for a specific directory entry using a part or
the whole of the last name and first name.
• Display a list of all matching entries as the results of a search.
• Allow the users to add a new entry to the directory.
• Allow users to access the telephone directory through a Web browser
and their Internet connection.
The preceding requirements are sufficient to begin developing the appli-
cation. The following sections provide a guide that can be used on a step-
by-step basis to develop the application.
The Database
An access database will be used to support this sample application. Any
database with an ODBC-compliant driver can be used. A new database that
contains only one table will be created to contain the directory entries. The
structure of the table is shown in Exhibit 2.
IDC requires an ODBC data source to communicate with the database.
Here, an ODBC data source is created for the access database that has just
been created using the 32-bit ODBC manager in the control panel.
Programming Tip: The datasource must be defined as a system datasource for
the Web server to be able to access it.
The datasource will be named Tel_Directory and pointed to the newly
created access database. Security will not be added to the database for
the purpose of this example. In a real-life application, one will most likely
Search WWH ::
Custom Search