andyc209
10-17-2005, 10:58 AM
I am good with ASP but have no idea how to use my ASP in Flash, so bear with me.
I have a database with a list of stand numbers for a show which I use ASP to get a list of all the stands that are booked using something like:
<%
s="select * from stands where archive='0'"
set rs=db.execute(s)
%>
<%
while not rs.eof
%>
<%=rs("stand_number")%>
<%
rs.movenext
wend
rs.close
%>
Simple ASP script. The problem is I want to pass this list to Flash and on a floorplan, where stand 1 for example is booked the button over that stand becomes visible and activates an 'on mouse over' action - maybe by making a movie clip move forward a frame in the button. This is so when someone looks at the plan they can see the stand is sold as it has turned blue and on moving you mouse over the blue square little movie like an alt tag appears with the stand details which have also come from the ASP.
ANy help is much appreciated and thanks in advance.
I have a database with a list of stand numbers for a show which I use ASP to get a list of all the stands that are booked using something like:
<%
s="select * from stands where archive='0'"
set rs=db.execute(s)
%>
<%
while not rs.eof
%>
<%=rs("stand_number")%>
<%
rs.movenext
wend
rs.close
%>
Simple ASP script. The problem is I want to pass this list to Flash and on a floorplan, where stand 1 for example is booked the button over that stand becomes visible and activates an 'on mouse over' action - maybe by making a movie clip move forward a frame in the button. This is so when someone looks at the plan they can see the stand is sold as it has turned blue and on moving you mouse over the blue square little movie like an alt tag appears with the stand details which have also come from the ASP.
ANy help is much appreciated and thanks in advance.