problems with conditional with value from a record set 1

[robertl]

I have the following code where I'm having problems comparing the value that a user entered "upass" with that
retrieved from a database (RS('Password')) (which was assigned to pw for my ease of following).

<% uname=Request.Form(&quot;uname&quot;) %>
<% upass=Request.Form(&quot;upass&quot;) %>

<%

	CON=Server.CreateObject(&quot;ADODB.Connection&quot;)
	CON.Open(&quot;DSN=verify;&quot;)

	SQL = &quot;SELECT Password FROM mainpwl&quot;
	RS = CON.execute(SQL)
	pw = (RS('Password'))
	if (pw == &quot;upass&quot;)
	{
        	Response.Redirect(&quot;granted.htm&quot;);
	}
	else

When I run this ASP page, I find my problem is lying somewhere with the line

if (pw == "upass")

If I omit the quotes the condition does everything after the

else

if I put in quotes what upass should be (forcing it to be equivalent to pw), then I receive the correct results. If I omit the quotes to have

if (pw == upass)

then everything after the

else

is excuted.

What am I doing wrong?

Thanks.

 

[luciddream]

try making this:

pw = RS('Password').Value;

and:

if (pw == upass) adam@aauser.com