Solved

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

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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Questions about INCLUDE FILES 2 45
Change visitor's REMOTE_ADDR to server's REMOTE_ADDR 2 50
Weighted Randomizing 6 38
Asp in server side with Mssql Server 7 4 42
I recently decide that I needed a way to make my pages scream on the net.   While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one…
I have helped a lot of people on EE with their coding sources and have enjoyed near about every minute of it. Sometimes it can get a little tedious but it is always a challenge and the one thing that I always say is:   The Exchange of informatio…
The goal of the tutorial is to teach the user how to how to load their YouTube profile onto Flash Media Live Encoder.
The goal of the tutorial is to teach the user how to select the video input device. Make sure you have an input device that in connected and work and recognized by Adobe Flash Media Live Encoder and select it in the “video input” menu.

737 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