Lectora values to a Access database

Greetings.This subject has been dealt with before and I have followed and tried to implement it, but have had no success. Regarding passing values from lectora to an Access database, I have used the database example given in previous posts to send results from a two question test to an access database. While I receive the message, "Your test results have been submitted", when I look in the access file, the fields have not been populated. Can anyone help?I am using Lectora v. 2005 SP4A (2790)I first created the test, with the Submit results to: "myasp/saveresults.asp". (method is POST). I did not check "include all variable values in submission" as I am just taking the values from the test. I also checked "Prompt the student for their name to identify the test". When I published the finished test, I unchecked the "Title Manager". Here is the asp code. (saveresults.asp)


<%@ Language=VBScript %><%'Get the parameters posted from the test'testname=Request.form("TestName")score=Request.form("TestName_Score")name=Request.form("userName")numQuestions=Request.form("NumQuestions")passingGrade=Request.form("PassingGrade")trueFalse=Request.form( "TrueFalse" )multipleChoice=Request.form( "MultipleChoice" )'Validate that this is actually from a Lectora test'if testname="" Or score="" Or name="" Or numQuestions="" Or passingGrade="" Or trueFalse="" Or multipleChoice="" then Response.Write "" Response.Write "Failure " Response.Write "" Response.Write "STATUS=500" Response.Write "
" Response.Write "Could not parse test results due to a parameter error." Response.Write ""else 'Write the results to an access database' ' First let us create Connection and Recordset objects' set Conn = Server.CreateObject("ADODB.Connection") Conn.Open "PROVIDER=MICROSOFT.JET.OLEDB.4.0;" & "DATA SOURCE=" & Server.MapPath("fpdbtestresults.mdb") Set Rs = Server.CreateObject("ADODB.RecordSet") ' Now, create the SQL statement' sSQL = "INSERT INTO Result(TestName,PassingGrade,NumQuestions,MultipleChoice,Tru eFalse,userName,TestName_Score) VALUES ( '" & testname & "', " & passingGrade & ", " & numQuestions & ", " & multipleChoice & ", " & trueFalse & ", '" & name & "', " & score & ")" ' Execute the SQL statement, and set the recordset object' ' to the result of this execution. We obtain the resulting' ' records in Rs object' Set Rs = Conn.Execute(sSQL) ' Close the Recordset object and destroy it' Set Rs = Nothing ' You might want to release the resources for connection object, ' ' unless you want to use the same connection again in the later code' Conn.Close Set Conn = Nothing 'The response is optional, it is good for debugging' Response.Write "" Response.Write "Success " Response.Write "" Response.Write "STATUS=200" Response.Write "
" Response.Write(sSQL) Response.Write "
" Response.Write "Success." Response.Write ""end if%>


I made sure all fields in Lectora matched with that in Access, and that the field location were correct. ie. "fpdbtestresults.mdb" and "myasp/saveresults.asp"As I stated before, the test completed without any problem, the message ""Your test results have been submitted" appears, but no data is in the access database.Thanks in advance.Bruce

Discussions have been disabled for this post