home *** CD-ROM | disk | FTP | other *** search
/ sau9.org / sau9.org.zip / sau9.org / mathapp / student_report.asp < prev    next >
Text File  |  2002-11-11  |  2KB  |  63 lines
  1. <HTML>
  2. <head>
  3. <title> Mathworks Student Admin
  4. </title>
  5. </HEAD>
  6. <body>
  7.  
  8. <table width="90%" border="0">
  9.   <tr>
  10.     <td><font face="Arial"> <font size="6">Mathworks Student Management <br>
  11.        </font></font></td>
  12.     <td>
  13.       <div align="center"><img src="math.gif" width="177" height="141"></div>
  14.     </td>
  15.   </tr>
  16. </table>
  17. <%
  18. Dim csdConn
  19. Dim csdStudent
  20.  
  21. filePath = Server.MapPath("math_proj.mdb")
  22.  
  23. set csdConn=server.createObject("ADODB.connection")
  24.  
  25. csdConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & filePath
  26. %>
  27. <%
  28. set csdStudent=csdConn.execute ("SELECT tblStudent.idStudent, tblStudent.txtLName, tblStudent.txtFName, tblPerformance.intStatus, tblPerformance.cntPlaceAttempt, tblPerformance.cntOperBAttempt, tblPerformance.cntOperIAttempt, tblPerformance.cntOperAAttempt, tblStatusDescr.Description FROM tblStudent INNER JOIN (tblStatusDescr INNER JOIN tblPerformance ON tblStatusDescr.idStatusNum = tblPerformance.intStatus) ON tblStudent.idStudent = tblPerformance.idStudent ORDER BY tblStudent.txtLName")
  29.  
  30. %>
  31. <table border=1><tr><td>Student ID</td><td>First Name</td><td>Last Name</td><td>Status</td><td>Place Value <br>Attempts</td><td>Beg Oper</td><td>Int Oper</td><td>Adv Oper</td></tr>
  32. <% 
  33. do while not csdStudent.EOF
  34. id=csdStudent("idStudent")
  35. fname=csdStudent("txtFName")
  36. lname=csdStudent("txtLName")
  37. statusdesc=csdStudent("description")
  38. placecount=csdStudent("cntPlaceAttempt")
  39. OpBasic=csdStudent("cntOperBAttempt")
  40. OpInt=csdStudent("cntOperIAttempt")
  41. OpAdv=csdStudent("cntOperAAttempt")
  42. response.write "<tr><td>"
  43. response.write id
  44. response.write "</td><td>"
  45. response.write fname
  46. response.write "</td><td>"
  47. response.write lname
  48. response.write "</td><td>"
  49. response.write statusdesc
  50. response.write "</td><td>"
  51. response.write placecount
  52. response.write "</td><td>"
  53. response.write opBasic
  54. response.write "</td><td>"
  55. response.write opInt
  56. response.write "</td><td>"
  57. response.write opAdv
  58. response.write "</td></tr>"
  59. csdStudent.movenext
  60. loop
  61. response.write "</table>"
  62. %>
  63.