Hi,
I have no problem, using a request to my ODBC access database, when I'm building a dinamyc page, but, the problem begins when I try to put a flash video from the up button of the dreamweaver 8, and I try to use the database with it.

First I must apologize for my english, I hope you can understand what I'm saying.

When you insert a flash video with an static URL, you get this:

object classid="clsid:---------------------------" codebase="download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,0,0" width="320" height="240" id="FLVPlayer">
param name="movie" value="FLVPlayer_Progressive.swf" />
param name="salign" value="lt" />
param name="quality" value="high" />
param name="scale" value="noscale" />
param name="FlashVars" value=&MM_ComponentVersion=1&skinName=Clear_Skin_1&streamName=mivideo&autoPlay=false&autoRewind=false" />
embed src="FLVPlayer_Progressive.swf" flashvars=&MM_ComponentVersion=1&skinName=Clear_Skin_1&streamName=mivideo&autoPlay=false&autoRewind=false" quality=high" scale="noscale" width="320" height="240" name="FLVPlayer" salign="LT" type="application/x-shockwave-flash" pluginspage=macromedia.com/go/getflashplayer" />
/object>

where, "mivideo.flv" is the path, but, how do I do to insert a query to the database and insert correctly a flash video from it?.

I don't want to create 100 pages for 100 videos!. That's why the asp and databases were created for. But I almost can't write code......

When I browse to my database to insert a flash video using data sources, (database), says that the flash video must be numbers or letters, without space, or something like that, and do not charge the query. Can you help me?.

Regards from Spain,
Julian.

All you have to do is remove the file extension from the name of your file. This example reads the flash file for its heightand width. Do a search for swfheaddump (although it dosen't work in flash 8). otherwise you would need to add the height and width in the database.

<pre id=code><font face=courier size=2 id=code>
&lt;%
myFile = (RS.Fields.Item("Name of yourfile".Value)
'remove the file extension for the flash player
myPosition = inStr((myFile),"."
myFile = Left(myFile, myPosition -1)
%&gt;



&lt;object classid="clsid27CDB6E-AE6D-11cf-96B8-444553540000" codebase="download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,0,0" width="&lt;%= myWidth %&gt;" height="&lt;%= myHeight %&gt;" id="FLVPlayer"&gt;
&lt;param name="movie" value="FLVPlayer_Progressive.swf" /&gt;
&lt;param name="salign" value="lt" /&gt;
&lt;param name="quality" value="high" /&gt;
&lt;param name="scale" value="noscale" /&gt;
&lt;param name="FlashVars" value="&skinName=haloSkin_1&streamName=&lt;%= myFile %&gt;&autoPlay=true&autoRewind=true" /&gt;
&lt;embed src="FLVPlayer_Progressive.swf" flashvars="&skinName=haloSkin_1&streamName=&lt;%= myFile %&gt;&autoPlay=true&autoRewind=true" quality="high" scale="noscale" width="&lt;%= myWidth %&gt;" height="&lt;%= myHeight %&gt;" name="FLVPlayer" salign="LT" type="application/x-shockwave-flash" pluginspage="www.macromedia.com/go/getflashplayer" /&gt;
&lt;/object&gt;
</font id=code></pre id=code>

hi NIgel,
what do you mean that all you have to do is remove the flv extension from
the file name? I tried removing the .flv from the file names and it did not
work.

what happens is none of hte videos play.

For myFile = (RS.Fields.Item("Name of yourfile".Value), i put the value of my
data column from my table into the "name of yourfile" part. Is that correct?

Julian, Did you get this to work? If so, can you tell me how you did it?

Instead of:

param name="movie" value="FLVPlayer_Progressive.swf" /&gt;

Use:

param name="movie" value=&lt;%="folder_where_movies_stored/"&(rsRecordsetName.Fields.Item("video_file_name".Value)%&gt; /&gt;

i tried that and it didn't work...can you provide some more details please?

I'm trying to dynamically load .flv videos into the flash video player in dreamweaver.
I have an access database created where "videoPath" column provides the path
to the .flv file.

when I select this in the flash video players as a source file using hte data source
option, I get an error message telling me that "URL cannot contain special
characters or slashes".

Any ideas???

I'm trying to load dynamic .flvs using dreamweavers flash video players using ASP
and MSAccess Database.