Lesson 16. Flash, ColdFusion, and the Database
In this lesson, you'll complete the Dante quiz project. From the title of this lesson you might think that this is the hardest lesson in the book; in fact, the hard part is already behind you. In this lesson, you'll connect all the piecesFlash, th218 pages, and the databaseand do little else. Working with ColdFusion is like hooking up a VCR to your cable and your TV: the complicated parts are in the TV and VCR, but all you need to worry about is connecting a few wires from one component to the other. You'll save two pieces of data in Macromedia Flashthe username and score variablesinto a database. You'll then send this data to ColdFusion, and then ColdFusion will insert it into a database. This page is accessed via Flash, which sends data via the URL (notice the variables in the URL) when it calls the page. ColdFusion outputs the URL data in the page and also inserts the data into a database.Lesson 15, A Component-Based Flash Quiz , when you inserted the Flash movie usin220's <object> and <embed> tags, you appended a variable: flash/dante_quiz.swf?username=<cfoutput>#form.username#</cfoutput>. This variable was sufficient to get the username variable into Flash. One or more variables appended to the end of a URL in this way is called a querystring, and is a common approach to sending data between pages. In this lesson, rather than bringing data into Flash using a querystring, you'll send data out of Flash, using a querystring.