|
|
|
|
|
Active Server Pages
|
|
|
Active Server Pages (ASPs) are used for
Web applications. When you use ASPs, the transfer of information to and from
the database is "live". The ASP pages use the same DLL as the
application. This also means that the business rules are the same for the
application and the ASP pages. Each "insert", "update", and
"delete" SQL statement
updates the database tables instantly. Below is a sample of the code
used in my Virtual Placement Agency application for retrieving the list of positions available.
|
|
| <%
Set objPosition =
server.createobject("prjProjectBO.cPosition")
arrInfo=
objPosition.GetOpenPositions
For icounter = 0 to
ubound(arrInfo,2)
PositionID = arrInfo(0, icounter)
strTitle = arrInfo(1, icounter)
response.write "<center>"
response.write "<a href =
PositionProfile.asp?PositionID=" & PositionID &
">"& strTitle & "</a><p>"
Next
Set objPosition = nothing
%> |
|
|
The ASP pages are used to allow an Applicant to view a list of positions
found in the database. The Applicant has the ability to apply for the
positions that fit his/her qualifications. Upon login into the site, the
Applicant is required to enter his/her username along with the associated password.
|
|
|
If the Applicant logs in successfully, he/she then comes to a screen
displaying all the available positions. The user selects one and to view the details of that specific position.
|
|
 |
This following screen displays the information pertaining to the specific
position. By clicking the "Apply" link, the user is taken to the
Application Page.
|
|
 |
The page below shows where the user enters his/her pre-assigned Applicant ID
number. Once submitted, the Applicant ID and the Position ID are
saved to the database in a junction table.
|
|
 |
Once the Applicant has successfully applied for the position, a message
will appear thanking the user for their application and will display the
position number and the current date.
|
|
 |
|
|
|
|
|
|
|
