Flash & asp help...... urgent

1

Hi all… I’m working on creating a flash form that sends data to the DB. I was successfull in creating the page that can send the data to the DB but I’m not able to figure out a way to write the actionscript where the thanks message frame loads after we submit the data. As of now… when I submit it goes to the .asp page that I created to POST the data to the DB. Does anyone have any ideas?

Thank you.

HERE IS MY CODE:
ACTIONSCRIPT:

 on(release){
getURL("http://localhost/test/collegeForm.asp", "_self", "post");
}

ASP:

 <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<%
strColleges = Request.Form("colleges")
'Response.Write(strMajor) & "<br>"
'Response.Write(strColleges) & "<br>"
MyPath=Server.MapPath("uginfo.mdb")
Set Conn = Server.CreateObject("ADODB.Connection")
conn.Open "Driver={Microsoft Access Driver (*.mdb)};" & _
"DBQ=" & MyPath
SQL = "INSERT INTO collegeInfo (colleges) VALUES('"&strColleges&"')"
'Response.Write(SQL)
conn.Execute(SQL)
%>
<html>
<head>
<title>Information Submitted</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta http-equiv="refresh" content="3;URL=rooms2.html">
</head>
<body>
Your Information <%Response.Write(strColleges) & "<br>"%> has been successfully submitted to the database.
</body>
</html>
2

Use


on(release){
loadVariablesNum("http://yourSite.com/processForm.asp",0,"post");
gotoAndPlay("thankyou");
}

This line


gotoAndPlay("thankyou");

Tells flash to go to a frame with the label “thankyou”. There you can display a thank you message.

3

Thank you very much… it works great…