HOW TO? SQL Express > ColdFusion > Flash AS2.0
Here is my CURRENT development workspace.
- ColdFusion 8 Developer (client will use full version)
- SQL Express with active DB (client will use full version)
- Flash CS4 (using AS2.0 and Flashplayer 8 - limited by client security approved capabilities)
I have read COUNTLESS articles on how to link my flash project to SQL or CF. They are all relying on old(er) technology (MX or 2004). As well as confusion me. Adobe documentation is feeling less than what I would expect from Adobe.
What I have it is a small group of arrays that look like this...
Code:
bars.push({boxes:[[1, 10, 5], [2, 50, 6], [3, 10, 12]], id:"IMS"});
bars.push({boxes:[[1, 60, 10], [2, 50, 12], [3, 10, 5]], id:"IRE"});
bars.push({boxes:[[1, 30, 20], [2, 70, 10], [3, 15, 10]], id:"MP"});
bars.push({boxes:[[1, 23, 20], [2, 30, 70], [3, 7, 10]], id:"DBM"});
bars.push({boxes:[[1, 5, 5], [2, 70, 70], [3, 60, 10]], id:"IA"});
I have a DBA that has given me a QUERY to get the data required.
What I am not sure of is what do I have to do to connect my Flash (SWF) to the CF server given my available applications?
Given the amount of data to be transferred I guess I should not pass the variables through the URL.
Any help would be greatly appreciated. I was left to get this project done in the next 25 days by myself (that includes documenting and testing).
Thank you.