Hey guy's

I'm trying to compare a string sent by the User to data stored in the DB. Now when I send the results and stuff over I get the No Match found Statement that's in the Else statement .. and I know for a fact that the strings I'm comapring are in the Tables.

Now if i send strings over that doesn't exist in the table I get a Exeption Error Occured on Line 26 .. line 26 is the IF ***** Then line.

Here's my code

***************

Set rsResults = conn.Execute("SELECT Comp_PWD FROM Company WHERE Comp_UID = '" & UserName & "'")

if rsResults("Comp_PWD") = Request.Querystring("sPWD") Then
Response.Write "UserID and Password Matches"
else
Response.Write "No matching Results"
end IF

*****************

Thanks in advance