Flash Login Form to Asp

[Bill]

I have a simple flash login form with 2 fields: company & uid. I want to send these 2 variable to an ASP script that queries a database and redirects the browser to another url. I used:

on (release) {
getURL ("login_asp.asp", "", "POST");
}

on the submit button.

I've tried various ways of declaring the variable, but the asp script doesn't seem to be detecting these from flash. What am I missing?

Just so no confusion, I want to leave the movie (it's only an intro with a login) so I don't need anything passed back to the Flash movie. But does the asp script need to be any different than if it's receiving variables from an html form?

Bill

[edeveloper]

hi, if you are using getURL then you should be using a querystring to pass the vars to the asp page:
getURL ("login_asp.asp?var1=value1&var2=value2", "", "POST");

in the asp:
<%
dim var1,var2

var1 = request.querystring("var1")
var2 = request.querystring("var2")
%>

good luck

[Bill]

I inherited this and am new to asp, should I use loadVariable instead? here is the code:

<%

Dim dsnSrg
Dim userId
Dim password
Dim loginSql
Dim loginRs
Dim connLogin
Dim logRs
Dim logSql
Dim company

sub killObject()

connLogin.Close
Set connLogin = Nothing

end sub

dsnSrg = "lowen-furn"

Set connLogin = Server.CreateObject("ADODB.connection")
If Not IsObject(connLogin) Then
Response.Write "Database is temporarily unavailable"
Response.End
End If

connLogin.Open (dsnSrg)

'On Error Resume Next

company = Request.Form("company")
userID = Request.Form("uid")

logSql = "INSERT INTO user_log (log_uid, log_pw) VALUES ('" & userID & "','" & company &"')"
Set logRs = connLogin.Execute(logSql)


loginSql = "SELECT * FROM login WHERE userID = '" & userID & "'"
Set loginRs = connLogin.Execute(loginSql)


If loginRs.BOF Then
Response.write ("<FONT SIZE='+1'><B>Lowen furniture-graphics.com Login Denied. Customer ID# is invalid. Please click your browsers back button and try again.</B></FONT>")
killObject()
Response.End
End If


If loginRs.Fields("userID") = userID Then
Session("Authorization") = "true"
Response.Redirect "main/index.asp"
Else
Response.write ("<FONT SIZE='+1'><B>Lowen furniture-graphics.com Login Denied. Customer ID# is invalid. Please click your browsers back button and try again.</B></FONT>")
killObject()
Response.End
End If

killObject()

%>

[edeveloper]

yes. use loadVariables and check out my login and password with asp/flash at http://www.aspalliance.com/bellis