Solved

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

Posted on 2007-11-14
1
174 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

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

Hello, all! I just recently started using Microsoft's IIS 7.5 within Windows 7, as I just downloaded and installed the 90 day trial of Windows 7. (Got to love Microsoft for allowing 90 days) The main reason for downloading and testing Windows 7 is t…
I was asked about the differences between classic ASP and ASP.NET, so let me put them down here, for reference: Let's make the introductions... Classic ASP was launched by Microsoft in 1998 and dynamically generate web pages upon user interact…
In this tutorial viewers will learn how to create a basic motion tween animation in Flash Open a new document in Flash: Draw/import an image: Press CTRL + F8 to convert it into a graphic symbol: Select a frame (how long you want the tween to last): …
The goal of the tutorial is to teach the user how to set there setting in Adobe Flash Media Live Encoder and YouTube for optimal video and audio quality.

717 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