Grabbing a value from a Recordset and making it a link in a Flash button
Posted on 2007-11-14
I've got button that I've made in Flash (Flash 8). For the "action," I want it to be get URL() and the URL needs to be the web address that's coming from a recordset using ASP.
So if at the top of my page I've got...
set DBConn = Server.CreateObject("ADODB.Connection")
set rsArtist= Server.CreateObject("ADODB.Recordset")
sql4 = "select * from Resources where Volume = " & Request.QueryString("Volume") & " AND SessionGroup='" & Request.QueryString("SessionGroup") & "'"
How do I get that "SongURL" to be the URL in the getURL command of my button in Flash?