Flash Forms and ASP-Please Help!

1

Hi everyone,

I used one of your tutorials http://www.kirupa.com/developer/actionscript/forms_database.htm to learn the integration between Flash forms and Access Database. However, my program doesn’t work. It gives “Unupdatable Query” error. I’ve also tried looking at other related forums here. But I still can’t figure out how to solve the problem.

I’m using IIS,Access 2000 and i’m storing all my files in [color=#003366]C:\Inetpub\wwwroot estForm[/color]

[color=black]I’ve tried using getURL and loadVariableNum. My IIS works fine. Could anyone please help to highlight what am I doing wrong? Here are codes.[/color]

Code in Flash MX (instance name fname, lname, mailadd, message, submitBttn)


on(press)
{
loadVariableNum("processForm.asp",0,"POST");
}

Code in processForm.asp (created using DreamweaverMX)


<<A href="mailto:%@LANGUAGE="VBSCRIPT">%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "[http://www.w3.org/TR/html4/loose.dtd](http://www.w3.org/TR/html4/loose.dtd)">
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<%
Dim conn,sql_insert
strFirst = Request.Form("fname")
strLast = Request.Form("lname") 
strEmail = Request.Form("mailadd")
strMessage = Request.Form("message")
 
Response.Write(strFirst)&"<br>"
Response.Write(strLast)&"<br>"
Response.Write(strMail)&"<br>"
Response.Write(strMessage)
 
myPath=Server.MapPath("contactdb.mdb")
Set conn=Server.CreateObject("ADODB.Connection")
conn.Open "Driver={Microsoft Access Driver(*.mdb)};"&"DBQ="&myPath
sql_insert="INSERT INTO contact(FirstName,LastName,Email,Message)VALUES('"&strFirst&"','"&strLast&"','"&strMail&"','"&strMessage&"')"
conn.Execute sql_insert
%> 
</head>
<body>
 
</body>
</html>
2

Hi everyone,

I can’t seem to load the user inputs from the Flash Form into variables in ASP.
Could anyone help me? I sincerely appreciate your help.

Thank you.

3

A common problem for the “Updatable Query” is that the IUSR account on the web server must have write permissions.