Accessibility

Table of Contents

  1. Introduction
  2. Setting up Your Captivate Files
  3. Configuring Your JavaScript
  4. Setting up Your Database and ColdFusion Data Source
  5. Inserting the Data
  6. Creating an Excel Sheet on the Fly with Your Results

Storing Captivate Test Scores in a Database and Exporting Them To Excel with ColdFusion

Setting Up Your Database and ColdFusion Data Source

So far, so good. You’ve already created the Captivate files and have figured out how to configure the JavaScript code to display the test results. Next, you'll create your database in Microsoft Access, or use the database included with this tutorial, quizresults.mdb, included in the ZIP file you downloaded from the Requirements section. If you create your own database, use the following database schema.

Columns Attributes
id Autonumber
total Number
correct Number
accuracy number
name Text
email Text

Now, to create the ColdFusion data source, use the following steps:

  1. Log on to ColdFusion Administrator.
  2. Select Data Sources.
  3. For this example, type myQuiz for the name of the data source.
  4. Select the Microsoft Access driver.
  5. Click Add.
  6. For the Database File field, click Browse Server to locate your database, quizresults.mdb.
  7. Enter the database user name or password, if required.
  8. Click Submit.
  9. The ColdFusion administrator verifies your database connection. If it fails, check the file location, username, and password.

Next, you use ColdFusion to insert data into the database.

Page 4 of 6
Previous Page
Next Page