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"

I was having the same problem! Here is what I've found after long search: (found here (http://www.avdf.com/oct97/art_id002.html)

"Help, my Session variables disappeared!" Actually, that's probably what they were "supposed" to do (ahem!). If you change virtual directory or server, ASP allocates a new Session ID. Which sort of makes sense… and sort of doesn't. The net effect is that, for session variables to be maintained, you must stay within a directory (and its subdirectories).

Your redirect is probably changing directories too. I'm going to move my pages to the root and see if that helps. Good Luck! Gerard

If