Greetings,
Before you read below, note that all of this stemmed form this tutorial:
http://www.kirupa.com/developer/actionscript/forms_database.htm
I have created a flash movie that uses a form to submit information through ASP back to an Access DB using this line of code:
on(press){
loadVariablesNum(“http://localhost/web/processForm.asp",0,"post”);
gotoAndPlay(20);
}
What I’m confused about is how to get that data back out of Access into Flash.
I’m using the following ASP code to do what I think is the correct retreival :
<%@language = “VBScript” %>
<%
Dim conn
Dim strSQL
Dim rs
lookup = request.form(“sslookup”)
set conn = server.createobject(“ADODB.Connection”)
conn.open “PROVIDER=MICROSOFT.JET.OLEDB.4.0;DATA SOURCE=C:/Database/example.mdb”
set rs = Server.CreateObject(“ADODB.Recordset”)
strSQL = “SELECT * FROM contacts Where message=’”&lookup&"’;"
rs.open strSQL, conn
Do While not rs.EOF
Response.Write (rs(“FirstName”))
Response.Write “<br>”
rs.movenext
Loop
rs.Close
Set rs = nothing
set conn = nothing
%>
And this code in flash to try and get it :
on(press){
loadVariablesNum(“http://localhost/web/accessForm.asp",0,"post”);
}
I’d like to populate text fields within flash with my data from access.
Thanks in advance for any help.:thumb:
