Solved

Grabbing a value from a Recordset and making it a link in a Flash button

Posted on 2007-11-14
1
142 Views
Last Modified: 2010-04-03
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")
DBConn.Open session("dbConn_ConnectionString")
set rsArtist= Server.CreateObject("ADODB.Recordset")
sql4 = "select * from Resources where Volume = " & Request.QueryString("Volume") & " AND SessionGroup='" & Request.QueryString("SessionGroup") & "'"
rsArtist.open sql4,dbconn,3,3

SongURL= RSArtist("SongURL")

How do I get that "SongURL" to be the URL in the getURL command of my button in Flash?

Thanks!
0
Comment
Question by:brucegust
1 Comment
 
LVL 16

Accepted Solution

by:
anoyes earned 500 total points
ID: 20286491
As long as you're using Flash 6 or later, which I assume you are, you can use FlashVars.  Here's a tutorial about them: http://www.permadi.com/tutorial/flashVars/

So to use them w/ ASP, you'd have, for example,
<PARAM NAME=FlashVars VALUE="URL=<%=SongURL%>">

Now unfortunately I don't know how exactly you dig that out in Flash - I haven't done any ActionScripting in quite a while.  I'm sure you could find something by googling, but to get the ASP in there just use <%=SongURL%> where ever you want that songurl variable to be embedded.

Let me know if you have questions.
-Adam
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Sometimes you know that one object has a specific child in it, but you can't find the child. This happened to me when I was trying to code some actionScript to make a toolbar work with its embedded buttons.  My partner had created the toolbar usi…
This article describes a solution to a problem of subloading one movie into another when they have different SWF versions. Sometime back, I was working on an ActionScript project while I came across an interesting fact which I would like to share…
In this tutorial viewers will learn how to create a basic shape tween animation in Flash including shape hints for smooth animation Open a new document in Flash: Draw a shape: Select another frame (how long you want the tween to be): Right click and…
The goal of the tutorial is to teach the user how to use the auto adjust feature and what the different options do. When your video is not working right you can choose the auto adjust feature to help choose your settings.

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now