Looking for example or tutorial for populating a datafield in flash from CF

Question

On the Flash side I use the cs4 authoring environment with actionscript 2 I'm using CF8.  I have very little CF experience so any example that is simple yet through would be greatly appriciated....thanks

TheRealAgentK · Accepted Answer

Thanks. your example worked fine. Now when I use this cfm

        <cfquery name="qArtists" datasource="artgallery">
        SELECT FirstName
        FROM artists
        WHERE ArtistID = 1
        </cfquery>

    <cfoutput query="qArtists">#qArtists.FirstName#</cfoutput>

all I get in the textfield is undefined

If I run the cfm by itself it returns the first name of the artist with the ID of 1 as it should.

Ah, ok. So - the way the demo is built requires you to have a list of key/value pairs. E.g. in your example for pushing back one artist's name you'd need to do something along the lines of:

<cfoutput query="qArtists">lastName=#qArtists.FirstName#</cfoutput>

and then change the AS code in the frame to refer to the lastName key.

But really: If you wanted to query multiple DB columns and/or multiple records and push back a more complex dataset, I'd go with creating an XML structure in CF and getting Flash to load/parse that XML.

Cheers

Kai

TheRealAgentK · Answer

There are actually a variety of options and it depends on how you want to setup your architecture.

The first recommendation I'd like to make is to move to ActionsScript 3, that'll make your coding in Flash much better and also improves the integration. Moving to AS3 requires to compile against Flash Player 9, not sure if that's feasible for you.

There are basically multiple ways how you could connect Flash with CF:

1. loading name/value-pairs from a text file (static data)

2. loading a set of XML data from a .xml file (also static data)

3. doing the same as in 1 or 2 with dynamic data prepared in CF, e.g you load something like http://server.com/abc.cfm?id=65 and get dynamic text or xml data you could then process in Flash

4. there is something called Flash/Flex Remoting - if you've got business logic on the server that's available as CFCs, that's the best way to expose said business logic to a Flash-based client.

Probably for your use case the best option is to go with 1 or 2. If you have more data than just a date, think about using XML as a format as name/value-pairs are somewhat clumsy and hard to work with.

Maybe if you describe a bit more what exactly you're trying to do, I can point you to some links.

Cheers

Kai

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded