Hi Guys wondering if any one can help me with this pretty easy question. Just need to know how to call flash files out of an access 2000 database using ASP.

It is for an ecomm site and all the site is working and pulls out the jpegs/gifs of the products fine, however when ever I want to pull out a flash file it wont do it.

I have tried getting around this by putting the following into the access database field:

<object classid="blah, blah, blah, blah, " codebase="download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0" width="500" height="460">
<param name=movie value="file:filename.swf">
<param name=quality value=high>
<embed src="file:filename.swf" quality=high pluginspage="www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="500" height="460">
</embed>
</object>


However when I do this I get an graphical x telling me that there is a picture missing (ie it cant find anything) and the flash file that I want underneath it. So I obviously half way there.

If anyone could put me out of my misery and tell me where I am going wrong they woyuld be saving me from ripping even more of my hair out <img src=../images/dmxzone/forum/icon_smile_wink.gif border=0 align=middle>

BTW - I have all the correct record sets and ASP connect stuff defined and working successfully. Its just a matter of getting it to pull out the .swf correctly

To embed Flash movies dynamically e.g. from a database record use the following:


&lt;param name=movie value="&lt;%=(rsMyRSName.Fields.Item('YOURFIELDNAME').Value)%&gt;"&gt;
&lt;param name=quality value=high&gt;
&lt;embed src="&lt;%=(rsMyRSName.Fields.Item('YOURFIELDNAME').Value)%&gt;" quality=high pluginspage="www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="500" height="460"&gt;
&lt;/embed&gt;
&lt;/object&gt;

You are adding dynamic recordset data into the areas where you would usually embed a fixed pathname.

Make sure that the field which holds the Flash reference, is referencing the pathname of the Flash movie e.g. flash/mymovie.swf

Hope that helps!