Whats wrong with this?

TheShadow · 05-23-2005, 08:20 PM

Code:

<%

Set myConn = server.createObject("ADODB.Connection")
myConn.open "Orderinfo","IWSDstudent","assign2"

Set Login = server.createobject("ADODB.Recordset")
Login.open "SELECT * FROM contact WHERE contactID = '" & Request.form("username") "' AND contactPassword = '" & Request.Form("password") & "'", myConn, 2, 2

if login.eof then

login.close
connection.close

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

%>

Code:

Error: Access is Denied. 
Microsoft VBScript compilation error '800a0401' 

Expected end of statement 

/iwsd/iwsd019/assignment2/verify.asp, line 18 

Login.open "SELECT * FROM contact WHERE contactID = '" & Request.form("username") "' AND contactPassword = '" & Request.Form("password") & "'", myConn, 2, 2
----------------------------------------------------------------------------------^

TheShadow · 05-23-2005, 09:48 PM

I got rid of the issue above, yet still problem with not being able to login ...

Code:

<%

Set myConn = server.createObject("ADODB.Connection")
myConn.open "Orderinfo","IWSDstudent","assign2"

Set Login = server.createobject("ADODB.Recordset")
dim strSQL
strSQL = "SELECT * FROM contact "
strSQL = strSQL & "WHERE contactID = '" & Request.form("username") & "' "
strSQL = strSQL & "AND contactPassword = '" & Request.Form("password") & "'"

Login.open strSQL, myConn, 2, 2

if Login.eof then

Login.close
myConn.close

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

%>

Shouldnt have anything to do with the login.asp?

Code:

<?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>&nbsp;</p>
<p><img src="alumi.jpg" width="450" height="250" /></p>
<p><img src="login.jpg" width="300" height="150" /></p>
<form name="form1" id="form1" method="post" action="verify.asp">
  <p><img src="userpass.jpg" width="300" height="100" /></p>
  <p>
    <input name="username" type="text" maxlength="10" />
&nbsp;&nbsp;&nbsp;&nbsp;<input name="password" type="password" maxlength="12" />
</p>
  <p>&nbsp;  </p>
  <p>
    <input type="button" name="Login" value="Login" />&nbsp;
    <input type="reset" name="Reset" value="Reset" />
</p>
  <p>&nbsp;</p>
</form>
<p><img src="by.jpg" width="300" height="100" /></p>
</body>
</html>

TheShadow · 05-23-2005, 10:10 PM

How do i get out of this without looking like a complete fool ...

<input type="button" name="Login" value="Login" />

button should be submit