Lectora values to a Access database
June 1, 2006 12:00 AM
Good day tekprof and thanks for your help.I did the changes you suggested,
'Get the parameters posted from the test''testname=Request.form("TestName")'testname="myfirsttest"'passingGrade=Request.form("PassingGrade")'passinggrade="50"'numQuestions=Request.form("NumQuestions")'numQuestions="2"'multipleChoice=Request.form( "MultipleChoice" )'multipleChoice="1"'trueFalse=Request.form( "TrueFalse" )'trueFalse="1"'username=Request.form("userName")'username="Bruman"'testname_score=Request.form("TestName_Score")'testname_score="85"
and recived this message.
STATUS=200INSERT INTO Result(TestName,PassingGrade,NumQuestions,MultipleChoice,Tru eFalse,userName,TestName_Score) VALUES ( 'myfirsttest', 50, 2, 1, 1, 'Bruman', 85)Success.
Checked the access file and bingo! there it was.Went back into Lectora, checked the properties of the test to ensure the fields were the same as the access file and then ran the test. Again, no data of the test was carried into the access file.I even checked the "include all variable values in submission" option and changed the Submit results to: "saveresults.asp" under Test Properties, made sure that the saveresults.asp file was at the same level as the index.html page , and still no data was carried over.So it seems as you said, if there is data in the asp file then the asp file and database are OK, but between the Lectora test and the asp the data transfer is lost. And the problem may be staring me in the face but I can not think what else to change to correct the ptoblem.Regards
Discussions have been disabled for this post