Webmaster Forum / ColdFusion / Advanced Techniques / March 2007

Down to the basics. Does this display what you want?

<cfquery datasource="#application.db#" name="GetGig">
select *
from tblGigs
WHERE ADMINID = 6
</cfquery>

<cfoutput query="GetGig">
#paragraphformat(getgig.gigdesc)#
</cfoutput>

You are using 5 times the same variable name.. so the var is "overwrited" in
Flash and you get only the last one.
You need the to concatenate the getgig.gigdesc and show it in the textbox ? Or
you have different textboxes ?

REgards

Its as if the result doesnt loop in the Flash file...

I don't know if I get it rigth your situation, but I suppose something like :
You CF page returns the query in the url encoded var format
(var=1&var2=2&var=3...)
And in your flash, you have the loadvars or loadvariables("cfpage.cfm")
That will return the vars defined in the cfpage in your Flash (var, var1..)

Now.. how are you trying to use this vars in the Flash file ?...

You can't loop the result, you don't receive a recordset, just a collection of
variables. Copy the code or send it if you prefer.. both CF and Actionscript.

Regards

This is basically the same type of explanation, but it stems from the fact that
CF is a server side tehcnology and Flash is a client side technology.

In your situation, Flash is not loaded under after all the processing is done
and CF can only feed it whatever the last variable was. As stated, the variable
is technically being overwritten (or replaced) over and over until the last one
is recorded. This is why you only see the one record.

In order to get the results you want, you either need to build an output using
the appropriate Flash generating tags in CF  ([i]i.e. CFFORM can be designed to
create Flash output.[/i]) or you have to create a data or xml connector in your
own flash file using actionscript so it will draw the data itself.

You could compromise a bit and do both ... have Flash call an XML file for its
data, but target a CF page that generates an XML output.

The key is to leave your CFML code intact, irrespective of how you intend to use Flash. There are ways to just pass the query to Flash as a recordset.