Webmaster Forum / Flash / Data Integration / July 2008

Hello,

I don't know ASP but I do know PHP.  The concept for printing variables to
send to Flash is the same in any language.  So the idea is to send back to
Flash a string of variables with values that are separated by ampersands and
contain no line breaks.
In PHP, a typical query/result routine would look like this.

// After a successful connection to the server and database
$sql = "SELECT id FROM tableName";
$query = mysql_query($sql) or die(mysql_error());
$i = 1;
while($row = mysql_fetch_row($query)){
echo "id". $id . "=". $row[0] ."&"; // echo is used more often than print
$i++;
}
// Displays id1=Joe Bloggs&id2=Paul Smith&id3=Mary Lamb...etc

Is this how you're printing out your results from your query? If so, then good
thats what it's supposed to look like.

So then in Flash (using Actionscript 2.0), you would load the data using the
LoadVars object.

var lv:LoadVars = new LoadVars();
lv.load("myASP.asp");
lv.onLoad = function(success:Boolean)
{
if(success){
trace(this.loaded) // displays the data string above
} else {
trace("Error");
}
};

Do you have a similar routine in your Flash movie?  If so, then thats good
because LoadVars is the preferred method to load dynamic data into Flash.
 
There is another method to load dynamic data called loadVariables.
e.g. loadVariables("myASP.asp", this));

This does the same thing but doesn't give you much control over the data it's
loading.  If you are using this method then I suggest you switch to the
LoadVars object as it has methods that allow you to test if data has loaded
properly or not.  Also by creating an instance of the LoadVars object you can
access your data easily by using dot notation.  Using the LV object in the
script above you can get the value for id1 like this

lv.id1 // displays Joe Bloggs

If you're publishing and testing your files locally(thru IIS) then when your
SWF window appears go to Debug>List Variables and see if any data is loaded
into Flash.

Thats about all I know.  I hope something in here helps you?