Showcase and discover digital art at yex

Follow Design Stacks

Subscribe to our free newsletter to get all our latest tutorials and articles delivered directly to your inbox!

Setting Up Your Database and ColdFusion Data Source

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.