Whats wrong with this?

TheShadow · #1 May 23rd, 2005, 08:05

whats wrong with this .... doesnt seem to redirect to update.asp when its a valid login/password ...

<%
set myConn = server.createobject("ADODB.connection")
myConn.open "Orderinfo", "IWSDstudent", "assign2"
 
dim strUsername, strPassword, strSQL
strUsername = Request.Form("username") 
strPassword = Request.Form("password") 
strSQL = "SELECT * FROM contact "
strSQL = strSQL & "WHERE contactID = '" & strUsername & "' "
strSQL = strSQL & "AND contactPassword = '" & strPassword & "'"
 
set rs = myConn.Execute(strSQL)
If rs.EOF Then 
response.redirect "login.asp?message=" & Server.URLEncode("Invalid login name and/or password")
Else 
Session("username") = rs("username")
Session.Timeout=30
Response.redirect "details.asp"
End if 
 
rs.close
myConn.close
%>

Nitesh9999 · #2 May 23rd, 2005, 08:25

Code: Select all

Response.redirect "details.asp"

Is it redirecting to the wrong page?

TheShadow · #3 May 23rd, 2005, 08:40

Quote:

Originally Posted by Nitesh9999

Code: Select all

Response.redirect "details.asp"

Is it redirecting to the wrong page?

Sorry ... i meant

doesnt seem to redirect to details.asp when its a valid login/password ...

dont know where update.asp came from ...

D3mon · #4 May 23rd, 2005, 12:54

Check that your query actually returns a recordset. Be aware that your code isn't the most secure.

TheShadow · #5 May 24th, 2005, 04:45

Quote:

Originally Posted by D3mon

Check that your query actually returns a recordset. Be aware that your code isn't the most secure.

That isnt much of a concern at the moment ...

Shouldnt have anything to do with the login.asp?

Code: Select all

<?xml version="1.0" encoding="utf-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
  "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> 

<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">

<head>
	<title>Login</title>
	<link rel="stylesheet" type="text/css" href="Assign2.css">
<body>
<%
response.write cstr(request("message")) 
session.Abandon
set rs = nothing
%>


</p>


[img]alumi.jpg[/img]</p>


[img]login.jpg[/img]</p>
<form name="form1" id="form1" method="post" action="verify.asp">
  

[img]userpass.jpg[/img]</p>
  


    <input name="username" type="text" maxlength="10" />
<input name="password" type="password" maxlength="12" />
</p>
  

  </p>
  


    <input type="button" name="Login" value="Login" />
    <input type="reset" name="Reset" value="Reset" />
</p>
  

</p>
</form>


[img]by.jpg[/img]</p>
</body>
</html>

Trebz · #6 May 26th, 2005, 12:55

But is it redirecting to login.asp with your ?message= attached?

First step to debugging this is to figure which part of your If Else is actually firing, and then look at what the actuall running values are for the variables that control that if else block.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Whats wrong?	Bradfordp26	Web Page Design	11	Apr 5th, 2008 10:14
whats wrong with these 2 ?	batman13	JavaScript Forum	0	May 11th, 2007 19:29
Whats wrong with this?	MaccGaz	Other Programming Languages	1	Nov 4th, 2006 21:12
Whats wrong with this? (Ajax)	php_coder	JavaScript Forum	1	May 24th, 2006 20:48
Whats wrong with tables and why css	mrnthere	Web Page Design	7	Mar 16th, 2006 23:38

		Webforumz.com > Main Forums > Program Your Website > Classic ASP
Whats wrong with this?