Passing COld Fusion varialble to FLASH

[request]

I have created an intranet website using COld Fusion 4.0 and SQL Server.

Now, I have a table called as employee in SQL Server database with 3 fields -> employee_code, sound, message.

I need to pass the value of sound and message from Cold Fusion page to FLASH so that when the user logs on to the intranet, he hears that sound and sees the message animated on the screen.

Thanks for the help.

 

[twist]

there are two ways to do this.

1) pass them when you place the swf in the page, like so...
<PARAM NAME=movie VALUE=&quot;calendar.swf?premier=2&quot;>

that gives you a variable premier with a value of 2 when yous tart you're movie.

2) use the flash loadvariables() function to call a .cfm page which returns a list of variables like this:

&var1=#test#&var2=#test#&etc...

i usually put a &blank=blank on the end of my string cause it will load extra carrages and spaces into flash if they are on the end.

its pretty simple to get em in there. you can set up a loop that will show a loading screen until they are loaded and will save you from guessing and getting errors because you're variables haven't laoded