Hi,
I could really do with some help with my login process on the website I'm attempting to develop. I'm using Dreamweaver 8 for the design and Coldfusion 8 for the back end linked to a MS SQL 2005 DB.
I'm a complete novice when it comes to Coldfusion, and am teaching myself as I go along (so far, so good).
Everything has been working great so far, and I've managed to produce all sorts of wonderful stuff in rapid time (repeated regions linked to DB etc., - all really nice & easy) with the help of the help files which come with DW & CF. However, I'm really struggling with being able to logon registered users. I've created some basic test users on my DB to use. My other half picked up the Coldfusion MX Bible from the library to help me along (okay, it's the wrong version, but I thought that a lot of the content would still be valid)
I've worked through Chapter 40 which is all about logging in and authenticating users and whatnot. I've created a directory 'Secured' in my website as suggested and used the exact code in the book (modified slightly for my database of course) but my login doesn't work, doesn't do anything in fact ... here's the code
Secured/Application.cfm :-
Code:
<cfif isdefined("LoginForm.Logout")>
<cflogout>
</cfif>
<cflogin>
<cfif not isdefined("LoginForm.Login")>
<cfinclude template="login.cfm">
<cfabort>
<cfelse>
<!--- validate username/password here --->
<cfquery name="getlogin" datasource="cfmm">
SELECT Username FROM Users WHERE Username='#LoginForm.username#' AND pwd='#LoadForm.password#'
</cfquery>
<cfif getlogin.RecordCount is 0>
Invalid username/password. Try again.
<cfinclude template="login.cfm">
<cfabort>
</cfif>
<cfloginuser name="#LoginForm.username#" password="#LoginForm.password#" roles="#getlogin.groupID#">
</cfif>
</cflogin>
<!--- GetAuthUser() returns the empty string if not logged in --->
<cfif GetAuthUser() is not "">
<form method="post">
<input type="submit" name="logout" value="Logout">
</form>
</cfif>
Secured/login.cfm:-
Code:
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Logon</title>
<style type="text/css">
<!--
body,td,th {
font-size: small;
color: #CCCCCC;
}
body {
background-color: #000000;
}
-->
</style>
</head>
<body>
<p>Please enter your username and password</p>
<form method="POST" name="LoginForm" id="LoginForm">
<table width="36%" border="0" align="center">
<tr>
<td width="39%"><div align="right">Username : </div></td>
<td width="61%"><input type="text" name="username" id="username"></td>
</tr>
<tr>
<td><div align="right">Password : </div></td>
<td><input type="text" name="password" id="password"></td>
</tr>
<tr>
<td> </td>
<td><div align="right">
<input name="Login" type="submit" id="Login" value="Login" size="25">
</div></td>
</tr>
</table>
</form>
</body>
</html>
Clicking the Logon button, with or without valid user details in the username & password boxes results in the same thing; the page refreshes... and that's it !!!
If anyone can shed any light on what I've done wrong (I have no doubt that it
is me) it would be greatly appreciated.
Aplogies for being long winded, but I thought the more info the better,
Thanks in advance
C
Tutorialized Forums Sponsor:
October 6th, 2008, 05:13 AM
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
