home *** CD-ROM | disk | FTP | other *** search
/ sau9.org / sau9.org.zip / sau9.org / mathapp / student_changestatust.asp < prev    next >
Text File  |  2002-11-24  |  3KB  |  80 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 Change Student Status<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>IntStatus<td>Place Value <br>Attempts</td><td>Beg Oper</td><td>Int Oper</td><td>Adv Oper</td></tr>
  32. <% 
  33. response.write "<form action=student_status_conf.asp method=post>"
  34. dim iCount
  35. iCount=0
  36.  
  37. do while not csdStudent.EOF
  38. id=csdStudent("idStudent")
  39. fname=csdStudent("txtFName")
  40. lname=csdStudent("txtLName")
  41. statusdesc=csdStudent("description")
  42. intStatus=csdStudent("intStatus")
  43. placecount=csdStudent("cntPlaceAttempt")
  44. OpBasic=csdStudent("cntOperBAttempt")
  45. OpInt=csdStudent("cntOperIAttempt")
  46. OpAdv=csdStudent("cntOperAAttempt")
  47. response.write "<tr><td><input type=hidden name="
  48. response.write iCount & ".id value='"
  49. response.write id
  50. response.write "'>" & id & "</td><td>"
  51. response.write fname
  52. response.write "</td><td>"
  53. response.write lname
  54. response.write "</td><td>"
  55. response.write statusdesc
  56. response.write "</td><td><input type=text size =3 name="
  57. response.write iCount & ".intStatus value="
  58. response.write intStatus & "></td><td>"
  59. response.write "<input type=text size=3 name="
  60. response.write iCount & ".placecount value="
  61. response.write placecount & ">"
  62. response.write "</td><td><input type=text size=3 name="
  63. response.write iCount & ".opBasic value="
  64. response.write opBasic & ">"
  65. response.write "</td><td><input type=text size=3 name="
  66. response.write iCount & ".opInt value="
  67. response.write opInt & ">"
  68. response.write "</td><td><input type=text size=3name="
  69. response.write iCount & ".opAdv value="
  70. response.write opAdv & ">"
  71. response.write "</td></tr>"
  72. iCount=iCOunt +1
  73. csdStudent.movenext
  74. loop
  75. iCount=iCount - 1
  76. response.write "</table><input type=hidden name=count value="
  77. response.write icount & ">"
  78. response.write "<input type=submit value='Enter the student Changes!'>"
  79. %>
  80.