FDT 4 & Project Templates

If you install the final release of FDT4 the location of the FDT folder, which included the project types & project templates on Mac OS X has changed.
In the past it was located in your main Users folder:

[box] /Users/{yourusersname}/FDT[/box]

Now it has changed to

[box] /Users/{yourusersname}/Library/Application Support/FDT[/box]

you will see this folder structure

So as an example if you want to change your output folder from bin to deploy in your Empty AS 3 project, you would use this new location

[box] /{yourusersname}/Library/Application Support/FDT/projectTemplates/Web/EmptyAS3/description.xml[/box]

Mine reads like so

<?xml version="1.0" encoding="UTF-8"?>
<tns:projectTemplate xmlns:tns="http://fdt.powerflasher.com/ProjectTemplate"
	xsi:schemaLocation="http://fdt.powerflasher.com/ProjectTemplate ../../projectTemplate.xsd">

<name>Empty AS3 Project</name>
	<description>This template contains only the basic libraries to develop and compile a pure AS3 project.</description>
	<projectType>AS 3</projectType>

MySQL with FDT

Setting up FDT as a MySQL development environment using the Database Development perspective is quite easy. I assume that you have MySQL installed installed. The only other part you need is the J/Connector

Download the  Connector/J MySQL Database Driver.

The current version is 5.1.3, unzip the connectents of the file, and place it someplace. I put the file in my common libs folder, I was not sure if there was a place in the MySQL folder where drivers are located. The zip comes with a bunch of files but the only one you will need is the “mysql-connector-java-5.1.13-bin.jar”

Now in FDT, and switch to the “Database Development” perspective. (Window –> Open Perspective –> Other –> Database Development perspective)

[box] After you open the perspective choose a new connection [/box]

[box] On the pop-page of the Connection Profile Wizard, select the MySQL connection profile, name your connection, and then click next[/box]

[box] you will need to pick the type of driver that you want to use(we are using 5.1 here so pick that one)[/box]

[box] There are no drivers set up so click on the circle to the right of the pull down menu,and switch to the jar tab.[/box]

[box] there is a slight issue as the original driver here does not work, which is the reason for downloading the driver from MySQL, just delete the old one[/box]

[box] you should be left with only your driver, just point to the area where you saved it.[/box]

[box] set up your database information, and test the connection, you should see “ping succeeded”[/box]

[box] the original look of the newly created database[/box]

[box] to get to the data, right click on the database table and sample content or edit[/box]

[box] I went with edit,as it is a little cleaner I think, and there is also a window to write your own SQL! [/box]

That is all there is too it, you now how MySQL working inside of FDT.

You can also create database tables using this method.

[box] to start use the file menu, and create a new sql file, this allows you to include the sql file along with your project. this way is sloppy(sorry for that!) it is better to crate a new project and link it to the FDT project that you are working on, as this creates a new folder automatically for you. In my case I create a new sql file called meetings.sql and in it’s properties I link it to the project, and set up all the properties needed.[/box]

[box] In the newly created sql file you have the sql editor where you can create a new table with the properties you want, then just right click and execute. I did this in two steps to show that you can continue using the editor to do whatever you can do with sql. There is even sql code completion :)[/box]

[box] Each time you will be showed your results, and if you have any errors in your sql[/box]

[box] Now you can view the results in the Data Source Explorer, and then I show you can edit the data visually, or just sample the content. Below is a final image showing the results.[/box]

I hope you enjoyed the tutorial on setting up and working with MySQL with FDT

In part 3 of the series, we will set up the cross domain file, and create a flash remoting project with FDT 4 & ColdFusion 9 🙂

FDT & Coldfusion

Setting up the Environment

In the first part of the series of getting FDT & ColdFusion/MySQL to work for remoting we will focus on setting up the environment.

First I assume you have FDT, ColdFusion 9, and MySQL installed.

If you don’t:

Downloding CF Eclipse so you will have code completion, and some other goodies, it is free.

  • click next
  • agree to the license
  • wait for it to install and re start FDT

If you want to use cfeclipse open it’s perspective, but since we are just using it for writing cfcs for remoting that it not necessary.
The one thing that you will have to do if it bothered you as much as it did me, is to modify the top tollbar while in other perspectives not to show the tool bar from cfeclipse. this is easy to do.

right click on the tool bar, and pick customize perspective.

make sure CFEClipse and MXUnit is unchecked for the all other perspectives except cf eclipse. I don’t know why it does this, but it does, frusting!!

Also in the context menu there are new items, even in the FDT perspective.

I am not sure how I did it, but I got rid of the cfeclipse menus while working with the FDT prespective 🙂

to use cfeclipse in your FDT project just pick new file like you also do, but in this case pick other/cfeclipse

There is a nice wizard for creating the cfc. cfeclipse is a nice IDE for ColdFusion in Eclipse, if you are using ColdFusion I would recommend you check it out. Actually I just wanted something for the code hinting completion, but I will have to say that the features in cfeclipse are very nice!

You actually have everything you need to work with FDT & ColdFusion, but since we want database support that will be the next and final part of the set up.

I will update this post to show the set up with cfbuilder if you prefer using cfbuilder over cfeclipse.

Update: I got cfbuiulder installed and got RDS, and all the goodies working, however, the text editor did not! Also, to do this you need to uninstall cfeclipse first, it made such a mess of everything I had to re install FDT altogether! Stick with cfeclipse 🙂

Actually for the needs of working with flash remoting cfeclipse does more than what I  need, I wish I could just get the code editor with code completion, which is all I was really after. Yes a lot of work, but it is nice to be able to create & editor your ColdFusion files while in FDT and working with remoting.

In part 2 of the series I will show how to get MySQL working

Droid Does Flash meetup in San Francisco

There is a free upcoming event called DROID Does FLASH being hosted by Adobe at the Adobe Offices in San Francisco on September 16, 2010.

Event Details
Adobe Flash Player 10.1 is here on DROID smartphones by Motorola. Learn how you can get started creating and optimizing content for a great mobile Flash experience.

You can register by going to the website at http://flashmeetup.eventbrite.com/

Document Class in AS 3

A friend of mine from school send me an e-mail about how to set up the document class in Flash CS 5 & AS3. She is just starting out with flash, but I thought That I would write a blog about it as well in case anybody out their just starting out needs a demo.

Create a new AS 3 file in Flash CS 5

In the properties/publish panel settings click on the pencil to create a new actioscript class.

This window will pop u after you do this, call your class a name, I am calling it Main

Flash CS 5 will generate a as class for you that looks like:

package  {

	import flash.display.MovieClip;

	public class Main extends MovieClip {

		public function Main() {
			// constructor code


we will add a trace statement to the main function so the Main.as will become

package  {

	import flash.display.MovieClip;

	public class Main extends MovieClip {

		public function Main() {
			trace ("the main document class says hello");


Notice that thier is a default package, and that we imported the MovieClip class.
This is important as the Main Class extends the MovieClip class.
Document classes must either extend the MovieClip or Sprite class.

If they are animations with frames, or methods and functions of movie clips, the class will need to extend  the MovieClip class.
Otherwise, if you only need Sprite functionality, just use Sprite instaed.

in fact in this example I should have used Sprite instead of the MovieClip, but want to just use what Flash CS 5 generated.

save both files, and in the main fla use command +enter to test movie, and you will see the trace statement in the output window