jscript conditonal upon data retrieval from DB 1

[robertl]

I have the following snippet of code in an ASP page:

<% 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 User_Name, Password FROM mainpwl&quot;
	RS = CON.execute(SQL)
	IF RS(&quot;Password&quot;) = upass AND RS(&quot;User_Name&quot;) = uname THEN
		Response.Redirect &quot;granted.htm&quot;
	ELSE

I'm wanting to compare the recordset password and user name
to those entered by the user on a previous page (thus the
request.form). However, with this code as seen above I receive an error that a ";" is required. I already had this working in VBScript, but with a tip I received yesterday with another problem, I had to change my server side scripting over to javascript in order to dynamically view the files within a folder.

Thanks in advance.

 

[luciddream]

IF(RS("Password&quot == upass AND RS("User_Name&quot == uname)
{
Response.Redirect "granted.htm"
}
ELSE
adam@aauser.com

 

[robertl]

Thanks, different from what I tried this morning but now
theres a &quot" expected message pointing around the AND condition.

I know I must be close to getting this working.

 

[luciddream]

IF((RS("Password&quot == upass) && (RS("User_Name&quot == uname))



sorry. adam@aauser.com

 

[robertl]

Thanks, it appears that might work. I received an error
of "Object expected" so I included the statement

<%Response.Buffer = True%>

but that just creates another error in that "True" is not defined. I've read conflicting statements on different sites that Response.Redirect should not be used and that
people have used document.location instead should I be looking at different syntax in place of the response.redirect?

Thanks for your help.

 

[luciddream]

well, response.redirect cannot be used after content has been written to the client.

and i think you might want to use Response.Buffer = true;

i think True and true are 2 different things. adam@aauser.com