PART V: CONTINUING PROFESSIONAL EDUCATION This section should include information on continuing education activities which are
APPENDIX N
choose_prog.asp
<% @LANGUAGE = VBScript %> <%
Option Explicit
Dim connection, query, auth_user, user, pwd, auth %>
<%
’ Check if user has already logged in
’ If not, check if their pwd info is in database if Session("auth") <> "yes" then
user = Request.form("user") pwd = Request.form("pwd")
’ query to get the record matching the submitted username and password query = "SELECT school_name, username, password from login where query = query & “username='"
query = query & user & "'and password ='" & pwd & "'"
'Create database connection
set connection = Server.CreateObject("ADODB.Connection")
'Open connection
connection.open "alise"
'Send query, store results in "auth_user" set auth_user = connection.execute(query) If auth_user.BOF and auth_user.EOF then ' Recordset is Empty Session("auth") = "no" Response.Redirect("login.asp") Else
' User is now authorized, so set this session var Session("auth") = "yes"
' We'll need the school name for all inserts and updates ' in subsequent pages for this program, so set a session var Session("schoolName") = auth_user("school_name")
end if
end if
’ We need this variable to let next page of the app "progRed.asp" know it ’ is the first time we are visiting it
Session("recordPrograms") = "yes" %>
<html> <head>
<title>ALISE Questionnaire Program Choice Page</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> </head>
<body bgcolor="#FFFFFF"> <table width="100%" border="0"> <tr>
<td width="20%">
<p><img src="Images/top_logo.gif" width="175" height="65"><br> </p>
<table width="100%" border="0" bgcolor="#CCCCCC"> <tr>
<td><font face="Arial, Helvetica, sans-serif" size="2" color="#333366">Log In (questionnaire)</font></td>
</tr> <tr>
<td><font face="Arial, Helvetica, sans-serif" size="2" color="#333366">Students</font></td>
</tr> <tr>
<td><font face="Arial, Helvetica, sans-serif" size="2" color="#333366">Faculty</font></td>
</tr> <tr>
<td><font face="Arial, Helvetica, sans-serif" size="2" color="#333366">Curriculum</font></td>
</tr> <tr>
<td><font face="Arial, Helvetica, sans-serif" size="2" color="#333366">Income & Expense</font></td>
</tr> <tr>
<td><font face="Arial, Helvetica, sans-serif" size="2" color="#333366">Continuing
Education</font></td> </tr>
<tr>
ALISE members</font></td> </tr> </table> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> <p> </p> </td> <td width="80%" valign="top">
<img src="Images/topbar.gif" width="562" height="37"> <br>
<%
’Check if error message needs to display
’ This would be case if not program was checked
’ Session variable below would be set to yes on the page’libsci_1.asp’ if (Session("displayError") = "yes") then
’ We don’t need this session var set to yes anymore Session("displayError") = ""
%>
<br><br><font color="red"><b>You must enter at least one program offered by your school. Please try again
</b></font> <%
else end if %>
<table width="100%" border="0"> <tr>
<td width="95%" height="351">
<form method="post" action="progRed.asp"> <table width="550" border="0" cellpadding="3"> <tr>
<td height="20" colspan="2">
<div align="center"><b><font face="Arial, Helvetica, sans-serif">Program Choice Page<br><br>
</font></b></div> </td>
</tr> <tr>
mark each program that was offered by your school in <%=Session("schoolYear")%><br> </font></td> </tr> <tr> <td width="49%">
<input type="checkbox" name="ala_ls" value="11"> ALA-Accredited Master’s<br>
in Library Science</td> <td width="51%">
<input type="checkbox" name="ala_is" value="12"> ALA-Accredited Master’s<br>
in Information Science</td> </tr>
<tr>
<td width="49%">
<input type="checkbox" name="other_masters" value="2"> Other Master’s </td>
<td width="51%">
<input type="checkbox" name="other_grad" value="5"> Other Graduate </td>
</tr> <tr>
<td width="49%">
<input type="checkbox" name="post_masters" value="3"> Post-Master’s </td>
<td width="51%">
<input type="checkbox" name="doct" value="4"> Doctoral </td>
</tr> <tr>
<td width="49%"> <div align="left">
<input type="checkbox" name="bach" value="6"> Bachelor’s</div>
</td>
<td width="51%">
<input type="checkbox" name="other_under" value="7"> Other Undergraduate </td>
</tr> </table> <p>
<input type="submit" name="Continue" value="Continue"> </p>
</form>
<p> </p> </td> </tr> </table> <p> </p> </td> </tr> </table> <% connection.close
Set connection = Nothing %>
</body> </html>