<% function recordScore(iScore) { //Is a quiz in progress? if (Request.Cookies("QuizID") == "") return; //Get connected to the database connection = Server.CreateObject("ADODB.Connection"); connection.mode = 3; //ReadWrite Mode sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=c:/inetpub/wwwroot/rocks/_private/Quizzes.mdb"; connection.Open(sConnectionString); //Create the command sCommand = "insert into Scores ([QuizID], [Score]) values('" + Request.Cookies("QuizID") + "', " + iScore + ")"; //Issue the command connection.Execute(sCommand); //Check for Errors if (connection.errors.count > 0) Response.Write("recordAnswer connection error..."); //Close the connection connection.Close(); } %>