If PoorMansIsNull(CurQ) Then CurQ = 1 correct = 0 wrong = 0 End If
If PoorMansIsNUll(Answ) Then CurQ = CurQ + 1 If CurQ > (Your maximum number of questions) Then %> <p>Congratulations. You have completed this test. You missed <%=wrong%> questions, but got <%=correct%> questions right. That is equivilent to a <%=(correct/(max#ofQs)%>%. Thank you for doing the test. <% End If %>
<% set conntemp = server.createobject("adoDB.Connection") set myDSN = '(your DSN info goes here) conntemp.Open myDSN set MySQL = "SELECT * FROM QUESTIONS WHERE QuestionID=" & CurQ set rsTemp= conntemp.Execute(mySQL) %>
<h2>Question Number <%=rsTemp("QuestionID")%> </h2>
<% Else %> <% set conntemp = server.createobject("adoDB.Connection") set myDSN = '(your DSN info goes here) conntemp.Open myDSN set mySQL = "SELECT * FROM QUESTIONS WHERE QuestionID=" & CurQ set rsTemp= conntemp.Execute(mySQL) If AnsW = rsTemp("CorrectAns") Then %>
<p>Congratulations. You got it right. Whee</p> <% correct = correct + 1 %>
<% Else %>
<p>I'm sorry, you missed the question. You can review by reading: </p> <p><%=rsTemp("reference")</p> <% wrong = wrong + 1 %>