Marc,
You have a couple of different options. One would be to pass the names in
using the param tag that embeds the shockwave movie. Depending on how many
names you have, this may be the best idea. Try something like this:
<PARAM=SW1 VALUE="[<%
Do Until RsEmps.EOF
Response.Write("'" & RSEmps("Surname") & "', ")
RSEmps.MoveNext loop %>]">
Don't forget to do the same thing in the object tag for netscape users.
Then, when the movie begins simply get the value(externalParam("sw1")).
If you have a lot of names that need to be shown, another option would be
to query the .asp script when the movie begins. That script can be
basically exactly what you have before, but formatted into a list for easy
retrieval:
<%@ Language=VBScript %>
<%
set conn = server.createobject ("adodb.connection")
conn.open "dns_name", "", ""
set rsEmps = conn.Execute("select top 5 Surname")
Response.write("[")
Do Until RsEmps.EOF
Response.Write ("'"&RSEmps("Surname")&"', ")
RSEmps.MoveNext loop
Response.write("]")
conn.close set conn = nothing
%>
Note that I am writing all of this code directly into the e-mail so there
may be some syntax issues, but hopefully that will give you a good idea of
what you can do.
Brian Robbins
[EMAIL PROTECTED]
Senior Software Engineer, CleverMedia
http://www.CleverMedia.com/
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Marc Pidoux
> Sent: Friday, September 21, 2001 6:12 AM
> To: [EMAIL PROTECTED]
> Subject: <lingo-l> Sending ASP Variables to Director?
>
>
> How can you send multi variables to Director from an ASP Script on which
> the Director file is included?
> I am trying to get names from a database and to display them as a list
> in a text field.
>
> Thanks for your help,
>
> Marc
>
[To remove yourself from this list, or to change to digest mode, go to
http://www.penworks.com/LUJ/lingo-l.cgi To post messages to the list,
email [EMAIL PROTECTED] (Problems, email [EMAIL PROTECTED])
Lingo-L is for learning and helping with programming Lingo. Thanks!]
