Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
login page just not working in coldfusion
- Thread starter snivern
- Start date
- Thread starter
- #2
Here is all the code for the page
<cfif IsDefined("FORM.textfield"
>
<cfset MM_redirectLoginSuccess="clientsearch.cfm">
<cfset MM_redirectLoginFailed="no.cfm">
<cfquery name="dbquery" datasource="register">
SELECT username,password FROM register WHERE username='#FORM.textfield#' AND password='#FORM.textfield2#'
</cfquery>
<cfif dbquery.RecordCount neq 0 >
<cftry>
<cflock scope="Session" timeout="30" type="Exclusive">
<cfset Session.MM_Username=FORM.textfield>
<cfset Session.MM_UserAuthorization="">
</cflock>
<cfif IsDefined("URL.accessdenied" AND false>
<cfset MM_redirectLoginSuccess=URL.accessdenied>
</cfif>
<cflocation url="#MM_redirectLoginSuccess#" addtoken="no">
<cfcatch type="Lock"><!--- code for handling timeout of cflock --->
</cfcatch>
</cftry>
</cfif>
<cflocation url="#MM_redirectLoginFailed#" addtoken="no">
<cfelse>
<cfset MM_LoginAction=CGI.SCRIPT_NAME>
<cfif CGI.QUERY_STRING NEQ "">
<cfset MM_LoginAction=MM_LoginAction & "?" & XMLFormat(CGI.QUERY_STRING)>
</cfif>
</cfif>
<title>index2</title>
<p>Please enter your login information below:</p>
<form action="<cfoutput>#MM_loginAction#</cfoutput>" method="POST" name="loginform" id="loginform">
<table width="300" height="160" border="1">
<tr>
<th width="155" scope="row">Username:</th>
<td width="155"><input type="text" name="textfield"></td>
</tr>
<tr>
<th scope="row">Password:</th>
<td><input type="text" name="textfield2"></td>
</tr>
<tr>
<th scope="row"> </th>
<td><input type="submit" name="Submit" value="Submit"></td>
</tr>
</table>
<p> </p>
<p> </p>
<p> </p>
</form>
<p> </p>
<cfoutput></cfoutput><cfoutput></cfoutput>
<cfif IsDefined("FORM.textfield"
><cfset MM_redirectLoginSuccess="clientsearch.cfm">
<cfset MM_redirectLoginFailed="no.cfm">
<cfquery name="dbquery" datasource="register">
SELECT username,password FROM register WHERE username='#FORM.textfield#' AND password='#FORM.textfield2#'
</cfquery>
<cfif dbquery.RecordCount neq 0 >
<cftry>
<cflock scope="Session" timeout="30" type="Exclusive">
<cfset Session.MM_Username=FORM.textfield>
<cfset Session.MM_UserAuthorization="">
</cflock>
<cfif IsDefined("URL.accessdenied"
AND false><cfset MM_redirectLoginSuccess=URL.accessdenied>
</cfif>
<cflocation url="#MM_redirectLoginSuccess#" addtoken="no">
<cfcatch type="Lock"><!--- code for handling timeout of cflock --->
</cfcatch>
</cftry>
</cfif>
<cflocation url="#MM_redirectLoginFailed#" addtoken="no">
<cfelse>
<cfset MM_LoginAction=CGI.SCRIPT_NAME>
<cfif CGI.QUERY_STRING NEQ "">
<cfset MM_LoginAction=MM_LoginAction & "?" & XMLFormat(CGI.QUERY_STRING)>
</cfif>
</cfif>
<title>index2</title>
<p>Please enter your login information below:</p>
<form action="<cfoutput>#MM_loginAction#</cfoutput>" method="POST" name="loginform" id="loginform">
<table width="300" height="160" border="1">
<tr>
<th width="155" scope="row">Username:</th>
<td width="155"><input type="text" name="textfield"></td>
</tr>
<tr>
<th scope="row">Password:</th>
<td><input type="text" name="textfield2"></td>
</tr>
<tr>
<th scope="row"> </th>
<td><input type="submit" name="Submit" value="Submit"></td>
</tr>
</table>
<p> </p>
<p> </p>
<p> </p>
</form>
<p> </p>
<cfoutput></cfoutput><cfoutput></cfoutput>
NetworkGuy101
IS-IT--Management
You might want to check you datasource in your query.
<cfquery name="dbquery" datasource="register">
SELECT username,password FROM register WHERE username='#FORM.textfield#' AND password='#FORM.textfield2#'
</cfquery>
Where you have "register" as your datasource you also have register as the table you are pulling the username and password fields from. I ran the same code on my server with a little modification make sure your table fields are correct also. Here it is:
<cfif IsDefined("FORM.textfield">
<cfset MM_redirectLoginSuccess="clientsearch.cfm">
<cfset MM_redirectLoginFailed="no.cfm">
<cfquery name="dbquery" datasource="IGNEW">
SELECT user,password FROM access WHERE user='#FORM.textfield#' AND password='#FORM.textfield2#'
</cfquery>
<cfif dbquery.RecordCount neq 0 >
<cftry>
<cflock scope="Session" timeout="30" type="Exclusive">
<cfset Session.MM_Username=FORM.textfield>
<cfset Session.MM_UserAuthorization="">
</cflock>
<cfif IsDefined("URL.accessdenied" AND false>
<cfset MM_redirectLoginSuccess=URL.accessdenied>
</cfif>
<cflocation url="#MM_redirectLoginSuccess#" addtoken="no">
<cfcatch type="Lock"><!--- code for handling timeout of cflock --->
</cfcatch>
</cftry>
</cfif>
<cflocation url="#MM_redirectLoginFailed#" addtoken="no">
<cfelse>
<cfset MM_LoginAction=CGI.SCRIPT_NAME>
<cfif CGI.QUERY_STRING NEQ "">
<cfset MM_LoginAction=MM_LoginAction & "?" & XMLFormat(CGI.QUERY_STRING)>
</cfif>
</cfif>
<title>index2</title>
<p>Please enter your login information below:</p>
<form action="<cfoutput>#MM_loginAction#</cfoutput>" method="POST" name="loginform" id="loginform">
<table width="300" height="160" border="1">
<tr>
<th width="155" scope="row">Username:</th>
<td width="155"><input type="text" name="textfield"></td>
</tr>
<tr>
<th scope="row">Password:</th>
<td><input type="text" name="textfield2"></td>
</tr>
<tr>
<th scope="row"> </th>
<td><input type="submit" name="Submit" value="Submit"></td>
</tr>
</table>
<p> </p>
<p> </p>
<p> </p>
</form>
<p> </p>
<cfquery name="dbquery" datasource="register">
SELECT username,password FROM register WHERE username='#FORM.textfield#' AND password='#FORM.textfield2#'
</cfquery>
Where you have "register" as your datasource you also have register as the table you are pulling the username and password fields from. I ran the same code on my server with a little modification make sure your table fields are correct also. Here it is:
<cfif IsDefined("FORM.textfield"
><cfset MM_redirectLoginSuccess="clientsearch.cfm">
<cfset MM_redirectLoginFailed="no.cfm">
<cfquery name="dbquery" datasource="IGNEW">
SELECT user,password FROM access WHERE user='#FORM.textfield#' AND password='#FORM.textfield2#'
</cfquery>
<cfif dbquery.RecordCount neq 0 >
<cftry>
<cflock scope="Session" timeout="30" type="Exclusive">
<cfset Session.MM_Username=FORM.textfield>
<cfset Session.MM_UserAuthorization="">
</cflock>
<cfif IsDefined("URL.accessdenied"
AND false><cfset MM_redirectLoginSuccess=URL.accessdenied>
</cfif>
<cflocation url="#MM_redirectLoginSuccess#" addtoken="no">
<cfcatch type="Lock"><!--- code for handling timeout of cflock --->
</cfcatch>
</cftry>
</cfif>
<cflocation url="#MM_redirectLoginFailed#" addtoken="no">
<cfelse>
<cfset MM_LoginAction=CGI.SCRIPT_NAME>
<cfif CGI.QUERY_STRING NEQ "">
<cfset MM_LoginAction=MM_LoginAction & "?" & XMLFormat(CGI.QUERY_STRING)>
</cfif>
</cfif>
<title>index2</title>
<p>Please enter your login information below:</p>
<form action="<cfoutput>#MM_loginAction#</cfoutput>" method="POST" name="loginform" id="loginform">
<table width="300" height="160" border="1">
<tr>
<th width="155" scope="row">Username:</th>
<td width="155"><input type="text" name="textfield"></td>
</tr>
<tr>
<th scope="row">Password:</th>
<td><input type="text" name="textfield2"></td>
</tr>
<tr>
<th scope="row"> </th>
<td><input type="submit" name="Submit" value="Submit"></td>
</tr>
</table>
<p> </p>
<p> </p>
<p> </p>
</form>
<p> </p>
This is what jumps out at me in being where your problem is:
<cfif IsDefined("URL.accessdenied" AND false>
<cfset MM_redirectLoginSuccess=URL.accessdenied>
</cfif>
Actually, in the first line, "cfif IsDefined("URL.accessdenied" AND false". What exactly is this supposed to mean? What is supposed to be "False"? Basically, you're saying "If it's defined and has no definition." I think that CF is getting confused by this statement and setting the variable and redirecting to the "Access Denied" page.
Try dropping the "AND false" or coming up with a clearer IF statement. I think if you drop the "AND false", it may work as it is.
Hope This Helps!
Ecobb
- I hate computers!
<cfif IsDefined("URL.accessdenied"
AND false><cfset MM_redirectLoginSuccess=URL.accessdenied>
</cfif>
Actually, in the first line, "cfif IsDefined("URL.accessdenied"
AND false". What exactly is this supposed to mean? What is supposed to be "False"? Basically, you're saying "If it's defined and has no definition." I think that CF is getting confused by this statement and setting the variable and redirecting to the "Access Denied" page. Try dropping the "AND false" or coming up with a clearer IF statement. I think if you drop the "AND false", it may work as it is.
Hope This Helps!
Ecobb
- I hate computers!
NetworkGuy101
IS-IT--Management
Im not sure what that meant either but I ran it and it worked.
- Status