asp+flash+db

[Antonello Sale]

i’m using a db access and i added a field call “link_swf” where i wrote the url linking to a swf file, different for each record of the db(movie1.swf, movie2.swf etc.)

In my asp page I inserted a flash movie that I setup like this:
<embed src="top100/<%=link_swf%>" width="195" height="250" quality="high"

“top100” is the folder where I saved all my swf files and “link_swf “ it’s the name of db record

when I call my asp page the flash file is not loaded properly! What’s wrong?

If I call the flash file externally everything works perfectly

Could you help me?

Ale

[Newsgroup_User]

<%=link_swf%>

Unless you've already retrieved the link name and stored it in a local
variable called link_swf, this will be blank.
If you're pulling from a recordset, you should have
<%=myRS.Fields.Item("link_swf").Value%> .

[Antonello Sale]

i've already declared a variable!

sSql="SELECT Prodotti.Prodotto,Prodotti.Titolo, Prodotti.Durata, Prodotti.Note, Prodotti.Trama, Registi.NomeRegista, Nazionalita.DescrizioneNazione, Prodotti.VietatoAiMinori, Prodotti.VHS, Prodotti.DVD, Prodotti.DataUscitaVHS, Prodotti.DataUscitaDVD, Prodotti.FileCopertina, Prodotti.link_swf, Prodotti.Trailer, TipiAudio.DescrizioneTipoAudio, GeneriFilm.DescrizioneGenere " & _
" FROM (((Prodotti LEFT JOIN Registi ON Prodotti.Regista = Registi.Regista) LEFT JOIN Nazionalita ON Prodotti.Nazionalita = Nazionalita.CodiceNazione) LEFT JOIN TipiAudio ON Prodotti.TipoAudio = TipiAudio.TipoAudio) INNER JOIN GeneriFilm ON Prodotti.Genere = GeneriFilm.Genere " & _
" WHERE (((Prodotti.Titolo)='" & Replace(Titolo, "'", "''") & "'))ORDER BY Prodotti.Titolo"


IF ERR.number=0 then
Note=rsDettaglioProdotto.Fields.Item("Note").Value & ""
ELSE
Note=""
END IF
IF ERR.number=0 then
FileCopertina=rsDettaglioProdotto.Fields.Item("FileCopertina").Value & ""
ELSE
FileCopertina=""
END IF
IF ERR.number=0 then
link_swf=rsDettaglioProdotto.Fields.Item("link_swf").Value & ""
ELSE
link_swf=""

Inside the db i need to specify the absolute url or just the name of the file swf to be loaded? Text

thank you

ale

[Newsgroup_User]

"ale75" <webforumsuser@macromedia.com> wrote in message
news:elr7sj$hvo$1@forums.macromedia.com...
> Inside the db i need to specify the absolute url or just the name of the
> file
> swf to be loaded? Text
>
> thank you
>
> ale
>

You can do either, but based on what you showed last time, I'd say just the
file name in your case.