Flash Quiz Results. Storing Flash Quiz Results in an Access Database. Storing Quiz Results. Storing quiz results is a four-step process. First, you identify the user who owns the HTTP session. Second, you send this user to the page that administers the quiz.
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
Storing Flash Quiz Results in an Access Database
<%connection = Server.CreateObject("ADODB.Connection");connection.mode = 3; //read-write modesConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data “+ “Source=C:\\TopSecret\\results.mdb;Persist Security “+ “Info=False";connection.Open(sConnectionString);//create the sql query to insert the datasQuery = "INSERT INTO SecretQuiz (UserName, Score) “ + "Values(“ + "'" + Session("MM_username") + "', “ + "'" + Request("score") + "')";connection.Execute(sQuery);if (connection.errors.count > 0) Response.Write("<br>There was a connection error.");else Response.Write("<br>The score was recorded.");connection.Close();