Re: FLASH: VARS in Get URL

[Helen Triolo]

Mike Krisher wrote:

> 

> I say you try your method on Netscape before going any further, I have tried

> using variables in the GetURL action, along with other people, and I haven't

> heard of anyone getting it to work in Netscape. If there is a way to do it

> in Netscape could someone let me know, I posted a question about this last

> week and no one repsonded.

> 

> Michael Krisher


Michael/Mike,

Maybe variables and GetURL don't work together, but you could use a

textfield (and make it hidden and fill it with a Set Variable stmt).  I

put an example at http://i-technica.com/flash/passavar.html.  In the

example, you enter a record # (1, 2 or 3, where 1=www.webtech.net,

2=www.macromedia.com, 3=i-technica.com) and press Go.  This calls

passavar.asp, which returns the URL associated with that record from a

database.  You'll see the URL in frame 2.  Then press Go again and a new

window opens with the URL. The final frame does the GetURL with the

textfield as a "parameter".  I tried to put comments in to explain all

the actions in the fla.  The asp contents are listed below.  Forgive me

if you knew all this already--figured there's probably someone on the

list who doesn't!

Here's the asp:


<% 

Set conn = Server.CreateObject("ADODB.Connection")

conn.open "iTechnica","",""

sql = "SELECT iURL,sURL FROM urls WHERE urls.iURL=" &

Request.form("passed")


set rs = Server.CreateObject("ADODB.Recordset")

rs.Open sql, conn, 3, 3

rs.MoveFirst

  passback = rs.Fields("sURL")

rs.Close

conn.close


response.write("sGoToURL="+Server.URLEncode(passback))

%>


Regards,

Helen

__________________________________________________________________

i-Technica: Innovative Internet Solutions (http://i-Technica.com)

designeri-technica [dot] com

301-424-6037


flasher is generously supported by...

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

     flashforward2000 and The Flash Film Festival

  "The World’s Premier Flash Solutions Conference and Expo"

 March 27-29, Nob Hill Masonic Center, San Francisco, California


-Register before Feb 25 and save $200!!-- www.flashforward2000.com

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

To unsubscribe or change your list settings go to

http://www.chinwag.com/flasher or email

helpchinwag [dot] com