home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
sau9.org
/
sau9.org.zip
/
sau9.org
/
mathapp
/
page1.asp
< prev
next >
Wrap
Text File
|
2002-12-04
|
4KB
|
127 lines
<% Response.ExpiresAbsolute = Now() - 1 %>
<HTML>
<head>
<title> Login Verification
</title>
</HEAD>
<body>
<%
Dim csdConn
Dim filePath
filePath = Server.MapPath("math_proj.mdb")
set csdConn=server.createObject("ADODB.connection")
csdConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & filePath
Dim csdRS
set pw =request("pw")
set id = request ("id")
sql="SELECT tblStudent.idStudent, tblStudent.txtFName, tblStudent.pwStudent, tblPerformance.cntPlaceAttempt, tblperformance.cntOPerBAttempt, tblperformance.cntOperIAttempt, tblperformance.cntOperAAttempt, tblperformance.intstatus, tblStatusDescr.description FROM tblStudent INNER JOIN (tblStatusDescr INNER JOIN tblPerformance ON tblStatusDescr.idStatusNum = tblPerformance.intStatus) ON tblStudent.idStudent = tblPerformance.idStudent where tblstudent.idstudent="
sql=sql & id
'response.write sql
set csdRS=csdConn.execute(sql)
idStudent=id
Password=csdRs("pwStudent")
txtFname=csdRs("txtFname")
cntPlaceAttempt=csdRS("cntPlaceAttempt")
intstatus=csdRS("intstatus")
cntOperBAttempt=csdRS("cntOperBAttempt")
cntOperIAttempt=csdRS("cntOperIAttempt")
cntOperAAttempt=csdRS("cntOperAAttempt")
descr=csdRS("description")
if pw=Password then
csdConn.close
set csdRs=nothing
%>
<table width="90%" border="0">
<tr>
<td><font face="Arial"> <font size="6">Mathworks <br>
</font></font></td>
<td>
<div align="center"><img src="math.gif" width="177" height="141"></div>
</td>
</tr>
</table>
<%
'response.write cntOperBAttempt & "<P>"
'response.write idStudent
'response.write " Password from table=" & password
'response.write " intStatus= " & intstatus
'response.write "<p>"
'response.write cntOperBAttempt & "<P>"
response.write "<font face=tahoma size=5>Hello " & txtFName & "! Glad you could make it! <br><font size=3> Your status:"
response.write descr
Select case intStatus
case 1
response.write "<form action=place_tut.asp method=post>"
response.write "<input type=hidden name=level value="
response.write cntPlaceAttempt
response.write "><input type=hidden name=idStudent value="
response.write idStudent & "><input type=hidden name=intstatus value="
response.write intstatus
response.write "><input type=submit value=Continue></form>"
case 2
response.write "<form action=dec_add.asp method=post>"
response.write "<input type=hidden name=level value="
response.write cntOPerBAttempt
response.write "><input type=hidden name=idStudent value="
response.write idStudent & "><input type=hidden name=intstatus value="
response.write intstatus
response.write "><input type=submit value=Continue></form>"
case 3
response.write "<form action=dec_add.asp method=post>"
response.write "<input type=hidden name=level value="
response.write cntOPerIAttempt
response.write "><input type=hidden name=idStudent value="
response.write idStudent & "><input type=hidden name=intstatus value="
response.write intstatus
response.write "><input type=submit value=Continue></form>"
case 4
response.write "<form action=dec_add.asp method=post>"
response.write "<input type=hidden name=intplaceAttempt value="
response.write cntOPerAAttempt
response.write "><input type=hidden name=idStudent value="
response.write idStudent & "><input type=hidden name=intstatus value="
response.write intstatus
response.write "><input type=submit value=Continue></form>"
case 5
response.write " <br>All modules completed"
case else
response.write "Error"
end select
else
response.write "<font face=Tahoma color=red size=4>Oops, incorrect password, please press the back button and try again!"
end if
%></body>
</html>