Hi. I've developed a sign-in form in Flash. The form passes the
variables to an asp script. The problem is: I need the asp to check if
a user, or email address is already registered in the database. I will
paste the code here:
<%
dim vuser, adoCon, rsCheckUser, strSQL
vuser=0
Set adoCon = Server.CreateObject("ADODB.Connection")
adoCon.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" &
Server.MapPath("users.mdb")
Set rsCheckUser = Server.CreateObject("ADODB.Recordset")
strSQL = "SELECT tblUsers.User FROM tblUsers"
rsCheckUser.LockType = 3
rsCheckUser.Open strSQL, adoCon
Do While NOT rsCheckUser.EOF
If (Request.Form("user")) = rsCheckUser("user") Then
vuser = 1
Set adoCon = Nothing
Set rsCheckUser = Nothing
End If
rsCheckuser.MoveNext
Loop
Set adoCon = Nothing
Set rsCheckUser = Nothing
rsCheckUser.Close
%>
Then the script will load the variable "vuser" into flash, and if the
variable is 1 the user is already registered in the database, and 0
otherwise.
Please tell me what you think could be wrong. Thanks for reading!
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
