I've recently been assigned to create a large scale flash/coldfusion/sql solution and was hoping I could get some ideas on how best to proceed (I have my own battle plan, but this is a little beyond what I normally do so I could use some input). Basically, a client wants to have a web based admin tool that specifies flash content to be displayed on up to 5 LCD screens at each of many locations (each having 5 screens, and different content on each screen). Each location will have 1 computer; that will pull content relevant to that location from the admin tool server. That computer will then drive the content to its location's 5 LCD screens (using SideCar or some such). The content of an LCD screen is fairly simple; a .swf movie that basically consists of three different still frames that it loops through (each still frame being a picture with some text). These "slides" need to be editable from the admin tool, as does the master .swf file that loads them in (in case they want to change the overall transitions, order of the slides, background color, etc). The client wants the admin tool created such that no .fla flash file will ever have to be edited directly (so perhaps the SQL database storing image and text information so they can be pulled into the flash movie via variables or some such on the fly).
Anyway, this is a fairly daunting project and I want to make sure I have a solid battle plan to avoid backtracking; any input or strategy ideas you guys can offer would be much appreciated. Thank you.