Can't write value into Session items
Posted on 2006-05-31
I am using ASP & VBScript on Windows Server 2003 with SQL Server for database
I am having problem writing value to the Session items and I can't figure out why
I do not have the problem when using Access Database
Below is my code.....
Dim SQL, Rs, strUserID, strPassWD
strUserID = LCase(Request.Form("userid"))
strPassWD = Request.Form("passwd")
SQL = "SELECT * FROM [Members] WHERE uid = '" & strUserID & "'"
Set Rs = Conn.Execute(SQL)
If Not Rs.EOF Then
If strPassWD = Rs("upass") Then
Session("AdminLogin") = "true"
Session("UserID") = strUserID
Set Rs = Nothing
I try debug with Response.Write Session("AdminLogin") and nothing shows....