Solved

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

Posted on 2007-11-14
1
158 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

Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

While working over numerous projects I often had the requirement for doing a screen capture in AS3.0. Unfortunately I found no "ready made" solutions in google search that suited my requirements. But I did come across some great resources which help…
I have found that much of my time doing support ends up being a constant repetition of the same steps to different people.  Early on I stated using web pages with Frequently Asked Questions (FAQs) to alleviate most of the burden.  Sometimes this jus…
The goal of the tutorial is to teach the user how to live broadcast using Flash Media Live Encoder and connecting it to YouTube to broadcast. Log into your Youtube account, choose live stream settings, start live stream from Flash Media Live Enc…
The goal of the tutorial is to teach the user how to how to load their YouTube profile onto Flash Media Live Encoder.

815 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

10 Experts available now in Live!

Get 1:1 Help Now