- Getting Started
- Exercise 1: The Database, "myFlashComDb.mdb"
- Exercise 2: The ColdFusion Component, "FCS_Security.cfc"
- Exercise 3: The Flash Movie, "FCS_Secure.fla"
- Exercise 4: The Server-Side ActionScript, "main.asc"
- Testing the Application, Some Considerations
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 2 Users Table; Design View, MSAccess.
)
Figure 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 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).