home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
sau9.org
/
sau9.org.zip
/
sau9.org
/
mathapp
/
place_confirm.asp
< prev
next >
Wrap
Text File
|
2002-11-11
|
2KB
|
70 lines
<%@ Language=VBScript %>
<%
Response.Buffer = True
Function ChkString(string)
If string = "" Then string = " "
ChkString = Replace(string, "'", "''")
End Function
set tn = request.form("tn")
response.write "<table> <tr> <Td><Font face=tahoma size=4><h2> Place Value Questions "
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 & ".idQNum"
idNum = ChkString(Request.Form(strID))
strIntLevel=iLoop & ".intLevel"
intLevel=request.Form(strIntLevel)
strQues=iLoop & ".txtQuestion"
Ques =ChkString(Request.Form(strQues))
StrAns1=iLoop & ".Ans1"
Ans1=ChkString(Request.Form(strAns1))
StrAns2=iLoop & ".Ans2"
Ans2=ChkString(Request.Form(strAns2))
StrAns3=iLoop & ".Ans3"
Ans3=ChkString(Request.Form(strAns3))
StrAns4=iLoop & ".Ans4"
Ans4=ChkString(Request.Form(strAns4))
StrvalAns=iLoop & ".valAns"
valAns=ChkString(Request.Form(strvalAns))
sql_update = "UPDATE tblPlaceQues set txtQuestion='" & Ques & "', numSet='"
sql_update=sql_update & intLevel & "', Ans1='"
sql_update=sql_update & Ans1 & "', Ans2='"
sql_update=sql_update & Ans2 & "', Ans3='"
sql_update=sql_update & Ans3 & "', Ans4='"
sql_update=sql_update & Ans4 & "', valAnswer='"
sql_update=sql_update & valAns & "' WHERE idQNum="
sql_update=sql_update & idNum
'response.write sql_update
'response.write "<br>Loop=" & iLoop
'response.write "<br> Count=" & iCount
conn.Execute (sql_update)
' Done. Close the connection
next
%>
Your questions have been edited. <a href=place_admin.asp>Review </a> the questions.
</html>