Followup to Database results
June 7, 2006 12:00 AM
If you look under the recent post, this is really a follow-up to that one.Under test properties, under results tab, I choose "Submit Test to CGI program", choose "POST" and indicated "submit results to:saveresults.asp". (I used and modified the asp file from Lectora: 2004-03-04_162345_Database_example.zip )I also checked "Include all variable values in submission".Now within my ASP file, these are the entries to receive those Lectora varaibles. (Example of the main code)
<%@ Language=VBScript %><%'Get the parameters posted from the test'testname=Request.form("TestName")'score=Request.form("Score")name=Request.form("Name")numQuestions=Request.form("NumQuestions")passingGrade=Request.form("PassingGrade")trueFalse=Request.form( "TrueFalse" )multipleChoice=Request.form( "MultipleChoice" )elapsedtime=Request.form("ElapsedTime")allowedtime=Request.form("AllowedTime")currentdate=Request.form("CurrentDate")currenttime=Request.form("CurrentTime")browsertype=Request.form("BrowserType")answer1=Request.form("Answer1")answer2=Request.form("Answer2")answer3=Request.form("Answer3")answer4=Request.form("Answer4")answer5=Request.form("Answer5")'Validate that this is actually from a Lectora test'if testname="" Or passingGrade="" Or numQuestions="" Or multipleChoice="" Or trueFalse="" Or name="" Or score="" Or elapsedtime="" Or allowedtime="" Or currentdate="" Or currenttime="" Or browsertype="" Or answer1="" Or answer2="" Or answer3="" Or answer4="" Or answer5="" then ' Now, create the SQL statement' sSQL = "INSERT INTO Result(TestName,PassingGrade,NumQuestions,MultipleChoice,Tru eFalse,Name,Score,ElapsedTime,AllowedTime,CurrentDate,Curren tTime,BrowserType,Answer1,Answer2,Answer3,Answer4,Answer5) VALUES ( '" & testname & "', " & passingGrade & ", " & numQuestions & ", " & multipleChoice & ", " & trueFalse & ", '" & name & "', " & score & ", '" & elapsedtime & "','" & allowedtime & "','" & currentdate & "', '" & currenttime & "', '" & browsertype & "', '" & answer1 & "', '" & answer2 & "', '" & answer3 & "', '" & answer4 & "', '" & answer5 & "')"
As you see, I am capturing the TrueFalse and MultipleChoice variables.The submission of variables to the database is working correctly, except for the TrueFalse and MultipleChoice. When I complete all 5 questions successfully (100%), the database will record 1 answered correctly for the TrueFalse and 1 answered correctly for the MultipleChoice, even though it should be 2 for TrueFalse and 3 for MultipleChoice.The issue is not that data is not being passed into the database, but rather these two entries in question are not showing the correct values.I have checked the properties for each of the question types and I do have 2 TrueFalse questions and 3 MultipleChoice questions.Thanks for your support.
Discussions have been disabled for this post