home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
sau9.org
/
sau9.org.zip
/
sau9.org
/
mathapp
/
student_status_conf.asp
< prev
next >
Wrap
Text File
|
2002-11-24
|
2KB
|
62 lines
<%@ Language=VBScript %>
<%
Response.Buffer = True
Function ChkString(string)
If string = "" Then string = "0"
ChkString = Replace(string, "'", "'0'")
End Function
set tn = request.form("tn")
response.write "<table> <tr> <Td><Font face=tahoma size=4><h2> Student Confirmation "
response.write "</td><td> <img src=math.gif width=140></td></tr></table>"
Dim iCount
iCount= Request("Count")
filePath = Server.MapPath("math_proj.mdb")
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & filePath
Dim iLoop
for iLoop = 0 to iCount
' Receiving values from Form
strID=iLoop & ".id"
id = Request.Form(strID)
strplaceCount=iLoop & ".placecount"
cntPlaceAttempt=request.Form(strplaceCount)
strintStatus=iLoop & ".intstatus"
intStatus=request.form(strintStatus)
stropBasic=iLoop & ".opBasic"
cntOperBAttempt =ChkString(Request.Form(stropBasic))
stropInt=iLoop & ".opInt"
cntoperIAttempt=ChkString(Request.Form(stropINt))
stropAdv=iLoop & ".opAdv"
cntoperAAttempt=ChkString(Request.Form(stropAdv))
sql_update = "UPDATE tblperformance set intStatus='"
sql_update=sql_update & intStatus & "', cntplaceAttempt='"
sql_update=sql_update & cntplaceAttempt & "', cntoperBAttempt='"
sql_update=sql_update & cntoperBAttempt & "', cntoperIAttempt='"
sql_update=sql_update & cntoperIAttempt & "', cntoperAAttempt='"
sql_update=sql_update & cntoperAAttempt & "' WHERE idstudent="
sql_update=sql_update & id
'response.write sql_update
conn.Execute (sql_update)
' Done. Close the connection
next
%>
Student settings have been edited. <a href=student_changestatust.asp>Review </a> the information.
</html>