On 2007-03-13 20:09:51 +0000, "bob_reist" <webforumsuser@macromedia.com> said:
[quoted text, click to view] > I am a DBA and I provide data to the developers at my company in XML
> format. The developers create Flash graphics and use the XML to
> populate data variables. I want to start requiring the developers to
> make calls directly to my MySQL databases so anytime i have to make a
> change to the underlying data, I don't get stuck generating an updated
> XML file for the developers.
>
> My developers tell me a Flash graphic cannot make a call directly to a
> mySQL database. They say Flash has to reference a page in which
> variables are defined, such as an XML, PHP, ASP page etc. This page,
> they say, is generated from database info, but Flash does not directly
> make the call to the database ... that another programming technology
> (XML, PHP, etc.) does and has to parse the information, making it
> available to Flash.
>
> Can anyone weigh in on this and if so, point me to anything that would
> show how a Flash graphic can make a call directly to mySQL and get back
> the XML it needs ... heck, I can create the view so the database has
> the XML waiting for the call ... I just need to know if this is doable
> so I can better work with our developers.
>
> Thanks!
> :confused;
Hi Confused. To keep this clear here are your options:
Content developed in Flash version 8 or lower will require some form of
middleware solution to extract data from your mySQL DB and pass it to
Flash. This could PHP, ASP, CGI etc. The reason behind this is that the
version of the language these version of Flash use does not have
support for greater levels of integration beyond traditional web
paradigms
When Flash 9 is released (and this also applies to the already
available Flex 2) the version of Actionscript (3.0) has support for
binary socket development. Therefore it should be possible to create a
native mySQL connector with this version of Actionscript. Thus removing
the need to have scripts as a 'go-between' .
However, the Flash 9 VM is relatively new and therefore you may not get
buy-in from the business organization to move to a new version straight
away.
--
regs
m
------------------------------------
Mike Jones
FlashGen.Com
------------------------------------
w./
www.flashgen.com e./ forum_postsATflashgenDOTcom
b./ blog.flashgen.com
------------------------------------
