Flash Form results not loading to asp script

Hi,

I’m having a problem getting my data from input text fields to pass to the ASP script using getURL and “POST”. The input fields have var of **email **and password. The form works fine when an html form passes the same variables.

on the submit button, I have this code


on(press){
    //loadVariablesNum("*samplescript*.asp",0,"post");
    getURL("*samplescript*.asp",0,"post");
}

ASP script:

<%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>
<% 

Dim strEmail, strPassword

strEmail = Request.Form("email")
strPassword = Request.Form("password")

'testing
Response.Write(strEmail) & " is the input email" & "<br>"
Response.Write(strPassword) & " is the input password" & "<br>"

'database connection information
Dim myConnection
Set myConnection=Server.CreateObject("ADODB.Connection")
myConnection.ConnectionString="PROVIDER=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & Server.MapPath("*database*.mdb") & ";" & _
"Jet OLEDB:Database Password='*removed*'"
myConnection.Open

'SQL information
Dim loginSQL
loginSQL = "SELECT * FROM users WHERE Email = '" & strEmail & "'"
'normally, this is appended to the end, but I wanna read the database
' WHERE Email = '" & strEmail & "'"

'Recordset Information
Dim myRS
Set myRS=Server.CreateObject("ADODB.Recordset")
myRS.Open loginSQL, myConnection
'debugging, if no records match
Dim mainMessage, rsemail, rspassword
If myRS.EOF Then
    Response.Write("No entries detected. <br>")
    mainMessage="userInfo=false"
Else
    'debugging
    rsemail = myRS("Email")
    rspassword = myRS("Password")
    Response.Write(rsemail) & " is the recordset email" & "<br>"
    Response.Write(rspassword) & " is the recordset password" & "<br>"
    'end debugging
    
    If (StrComp(strPassword, rspassword, vbTextCompare) = 0) Then
        Response.Write("Password Checks Out. <br>")
        mainMessage="userInfo=true"
    Else
        Response.Write("Password Checked but does not match. <br>")
        mainMessage="userInfo=false"
    End If
End If

'Close the Connections
myRS.Close
Set myRS=Nothing
myConnection.Close
Set myConnection=Nothing

 %>

Everything works fine when the form is submitted from here:

<body>
<p>This page tests the form function period, so we can determine if the connections are working in the first place</p>
<form action="*samplescript*.asp" method="post"><br />
Email: <input type="text" size="30" name="email" /><br />
Password: <input type="password" size="30" name="password" /><br />
<input type="submit" />Submit
</form>
</body>

Can anybody let me know where to look to pass the variables from the input text fields?