Publishers of technology books, eBooks, and videos for creative people

Home > Articles

  • Print
  • + Share This

Exercise 1: The Database, "myFlashComDb.mdb"

The Database for this project is simple. It uses two database tables, "Users" and "Users_Ticket". Using Microsoft Access, or your favourite database software, create these tables similar to the ones shown in Figure 2 and Figure 3. Create the database with the name "myFlashComDb.mdb".

Figure 2Figure 2 Users Table; Design View, MSAccess.

Figure 3Figure 3 Users_Ticket Table; Design View, MSAccess.

After you have created the database, add some values to the Users table, particularly login, password, first name, and last name. Add a couple rows so you have something to test with.

Next, connect the database to the ColdFusion MX Server (see Figure 4). Log into the ColdFusion Administrator and add the datasource "myFlashComDb.mdb" to the Data Sources control panel.

Figure 4Figure 4 Register the MSAccess Database in the ColdFusion MX Administrator.

If you downloaded the example applications, you will need to manually register the database.

C:\Inetpub\wwwroot\flashcom\applications\informIT\myFlashComDb.mdb

With the database set up, let's move on to the fun stuff. We'll start with the ColdFusion Component, and then we'll move onto Flash and writing some Server-Side ActionScript (SSAS).

  • + Share This
  • 🔖 Save To Your Account

Related Resources

There are currently no related titles. Please check back later.