# Flash & asp help...... urgent

**URL:** <https://forum.kirupa.com/t/flash-asp-help-urgent/56604>\
**Category:** Uncategorized\
**Created:** [July 6, 2004, 2:18am UTC](https://forum.kirupa.com/t/flash-asp-help-urgent/56604 "2004-07-06T02:18:30Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![aspnewbee](https://avatars.discourse-cdn.com/v4/letter/a/439d5e/32.png) [@aspnewbee](https://forum.kirupa.com/u/aspnewbee)\
**Post date:** [July 6, 2004, 2:18am UTC](https://forum.kirupa.com/t/flash-asp-help-urgent/56604/1 "2004-07-06T02:18:30Z")

</div>

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:

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

```

ASP:

```auto
 <%@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> 

```

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [July 6, 2004, 3:17am UTC](https://forum.kirupa.com/t/flash-asp-help-urgent/56604/2 "2004-07-06T03:17:09Z")

</div>

Use

```auto

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

```

This line

```auto

gotoAndPlay("thankyou");

```

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

---

<div class="post-metadata">

**Author:** ![system](https://canada1.discourse-cdn.com/flex011/uploads/kirupa/original/3X/6/2/621e5c11736f46532526e61be85940af4230f3e5.png) [@system](https://forum.kirupa.com/u/system)\
**Post date:** [July 6, 2004, 12:08pm UTC](https://forum.kirupa.com/t/flash-asp-help-urgent/56604/3 "2004-07-06T12:08:46Z")

</div>

Thank you very much… it works great…

> [@Digitalosophy](#):
>
> Use
> 
> ```auto
> 
> on(release){
> loadVariablesNum("http://yourSite.com/processForm.asp",0,"post");
> gotoAndPlay("thankyou");
> }
> 
> ```
> 
> This line
> 
> ```auto
> 
> gotoAndPlay("thankyou");
> 
> ```
> 
> Tells flash to go to a frame with the label “thankyou”. There you can display a thank you message.