Quote:
Originally posted by rhs98
I did mean on the server...but hey, I don't even know why it would be useful.
hktang, your code does not look complete; the signup.asp uses a variable to redirect that is not listed, also member.asp that you include.
|
member.asp
<%
Class Member
Private varMemberID
Public Property Get memberID()
memberID = varMemberID
End Property
Public Function memberLogin(inputEmail, inputPassword)
strSQL = "exec memberLogin '" & inputEmail & "', '" & inputPassword & "'"
Set objMember = objConnection.Execute(strSQL)
If objMember.EOF Then
memberLogin = False
varMemberID = 0
Else
memberLogin = True
varMemberID = objMember("memberID")
End If
objMember.Close
Set objMember = Nothing
End Function
End Class
%>
Access Query
SELECT [memberID]
FROM member WHERE emailaddress=[@inputEmail] And password=[@inputPassword];
The varRedirectURL variable in signup.asp
If a user didn't signin first and click on member profile, the varRedirectURL variable will be something like this :
varRedirectURL = "/profile.asp"