[thelist] ok, simple asp string compare problem.

Brian Delaney brian.delaney at mccmh.net
Thu Oct 14 14:28:06 CDT 2004


I am brain dead and probably just missing something:

I have a user select from a drop down list:

<option value="1">IT Admin</option>

Then I get the adminperm value from the sql db. In this case it is equal 
to 1
this is stored in the objRS.

What happens is even though this statement is true: *IF 
objRS("adminperm")= Request.Form("txtAPP") Then
* it always falls to the else "you donot have proper permission"
????


If objRS.EOF Then
                strError = "- Invalid username or password<br>" & vbNewLine
            Else
                If objRS("password")= Request.Form("password") Then
                       * IF objRS("adminperm")= Request.Form("txtAPP") Then*
                            Session("loggedin") = True
                            Session("userid") = objRS("id")
                            Response.Redirect ("../itadmin.asp")
                            Response.End
                        Else
                           strError = "- You donot have proper 
permission -<br>" & vbNewLine
                        End IF
               Else
                    strError = "- Invalid username or password<br>" & 
vbNewLine
             End If
End IF

*
*
*
This message, including any attachments, is intended solely for the use of the named recipient(s) and may contain confidential and/or priveleged information.  Any unauthorized review, use, disclosure or distribution of this communication(s) is expressly prohibited.  If you are not the intended recipient, please contact the sender by reply e-mail and destroy any and all copies of the original message.


More information about the thelist mailing list