Home | Advertising Info97 USERS CURRENTLY ONLINE   
PowerASP
   Site Search Contact Us Wednesday, January 15, 2025  

  Active InfoActive Info  Display List of Info MembersMemberlist  Search The InfoSearch  HelpHelp
  RegisterRegister  LoginLogin
Classic ASP - General
 PowerASP Code Help Area : Classic ASP - General
Subject Info: Whats wrong with this? A d d  -  P o s tAdd P o s t
Author
Message << Prev Info | Next Info >>
TheShadow
Newbie
Newbie


Joined: May/23/2005
Online Status: Offline
Info: 5
Added: May/23/2005 at 5:14am | IP Logged Quote TheShadow

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

Code:

<%
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
%>

Back to Top View TheShadow's Profile Search for other info by TheShadow
 
cwilliams
Admin Group
Admin Group
Avatar

Joined: April/26/2004
Location: United States
Online Status: Offline
Info: 137
Added: May/23/2005 at 10:42am | IP Logged Quote cwilliams

I do not really see anything wrong with it actually.. must be something though..

not that that is helpfull... :(


Chris Williams
www.PowerASP.com

Half Price Sale on all CJWSoft applications Today Only
see details on www.powerasp.com main page

 



__________________


Chris Williams
http://www.PowerASP.com
Back to Top View cwilliams's Profile Search for other info by cwilliams
 
TheShadow
Newbie
Newbie


Joined: May/23/2005
Online Status: Offline
Info: 5
Added: May/23/2005 at 10:30pm | IP Logged Quote TheShadow

cwilliams wrote:

I do not really see anything wrong with it actually.. must be something though..

not that that is helpfull... :(


Chris Williams
www.PowerASP.com

Half Price Sale on all CJWSoft applications Today Only
see details on www.powerasp.com main page

 



Nor Can i ...

Back to Top View TheShadow's Profile Search for other info by TheShadow
 
TheShadow
Newbie
Newbie


Joined: May/23/2005
Online Status: Offline
Info: 5
Added: May/24/2005 at 12:46am | IP Logged Quote TheShadow


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>


Back to Top View TheShadow's Profile Search for other info by TheShadow
 
TheShadow
Newbie
Newbie


Joined: May/23/2005
Online Status: Offline
Info: 5
Added: May/24/2005 at 1:09am | IP Logged Quote TheShadow

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

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

button should be submit
Back to Top View TheShadow's Profile Search for other info by TheShadow
 

If you wish to make a comment to this info you must first login
If you are not already registered you must first register

  A d d  -  P o s tAdd P o s t
Printable version Printable version

Info Jump
You cannot add new info in this area
You cannot add to info in this area
You cannot delete your info in this area
You cannot edit your info in this area
You cannot create polls in this area
You cannot vote in polls in this area

   Active Server Pages Rule The World
Contact Us  
All artwork, design & content contained in this site are Copyright © 1998 - 2025 PowerASP.com and Christopher J. Williams
Banner ads ,other site logos, etc are copyright of their respective companies.
STATS Unless otherwise noted - All Rights Reserved.

Active Server Pages asp source code database MS SQL MS Access .mdb adovbs.inc cookies calendar codes sql commands scripts asp programming tutorials iis web server components CJWSoft ASPProtect ASPBanner ASPClassifieds www.aspprotect.com, www.cjwsoft.com,www.aspclassifieds.com,www.aspphotogallery.com