Skip to main content
A
Antonello Sale
Participant
December 13, 2006
Question

asp+flash+db

  • December 13, 2006
  • 1 reply
  • 392 views
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
This topic has been closed for replies.

1 reply

N
Newsgroup_User
Inspiring
December 13, 2006
<%=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%> .


A
Antonello SaleAuthor
Participant
December 14, 2006
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
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices