We?re in the beginning phase of putting together an application that will
essentially be a project tracker. All the data will be held in MS SQL 2K while
using Flash MX 2004 Pro for the interface. My developer is a genius when it
comes to SQL, ASP, ASP.Net, XML, Web Services, and I?m sure much more. He has
a little experience with older versions of Flash so I?m sure it won?t take much
time for him to get a handle on ActionScript 2.0.
So with knowing this, what do you think is the best method for getting the
data from SQL to Flash. He mentioned Web Services which sounds like a good
solution, but since this is our first time I?d like to hear what others have
used and what you think works best.
Also, are there any books out there on data and Flash MX 2004? I can?t seem to
find anything.
Thanks
chewbaccah - 18 Feb 2005 22:14 GMT
XML is certainly the easiest way to get information in and out of flash, and
flash has built-in components to utilize webservices. These components do add
to download time, so if that is an issue, you may consider LoadVars.
There is an excellent book out there called "Macromedia Flash MX 2004
Professional for Server Geeks." It is available at Barnes and Noble.com for
about $45.00.
hope this helps
Mark.P. - 21 Feb 2005 12:36 GMT
Thanks for the quick answer.
I went to the bookstore over the weekend and looked at the book you
suggested, but noticed it's really for ASP.Net, CF, and I think I saw Java too.
Luckily my company is changing everything over from ASP to .Net as we speak
but it's been taking some time. So that book will be good in about 6 ? 12
months and I?ll be sure to get it, but I don?t know much about either to do any
conversions.
Thanks
Wilvis - 23 Feb 2005 21:53 GMT
Hey Mark - if you're final application is remaining local, you should consider
MDM Zinc. You can connect flash to databases without the need for any
middleware. It's cheap and very good. Otherwise check out Flash Remoting, if
you have the cash that is...