|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Get inside! Sample the range of functionality easily built with JMSL Library for Time Series Data Analysis, Heat Maps, Portfolio Optimization, Monte Carlo Simulation, Stock Price Charting and more. Download Now! |
|
#1
October 23rd, 2004, 11:57 PM
|
|||
|
|||
|
Login error
Hello,
I try to make a login page using Coldfusion MX dreamweaver MX MS SQL. The login page just will not go to the page I want to log in and just keeps returning to the “Login Failed" page. I have checked my database and the password and they are correct. This is the code I have in the login page. Thanks very much in advance Claude 0023/admin_validation.cfm"> <cfset MM_redirectLoginFailed="admin_failure.cfm"> <cfquery name="MM_rsUser" datasource="ClearWebCF"> SELECT Username,Password FROM dbo.tbAdminLogin WHERE Username='#FORM.tfusername#' AND Password='#FORM.tfPassword#' </cfquery> <cfif MM_rsUser.RecordCount NEQ 0> <cftry> <cflock scope="Session" timeout="30" type="Exclusive"> <cfset Session.MM_Username=FORM.tfusername> <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><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html> <head> <title>Untitled Document</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> </head> <body> <form name="form1" method="POST" action="<cfoutput>#MM_loginAction#</cfoutput>"> <table width="300" border="1" cellspacing="1" cellpadding="1"> <tr> <td>Username</td> <td><input name="tfusername" type="text" id="tfusername"></td> </tr> <tr> <td>Password</td> <td><input name="tfPassword" type="text" id="tfPassword"></td> </tr> <tr> Ps I am very new at using those tools
|
|
#2
October 26th, 2004, 08:13 AM
|
|||
|
|||
|
Most likely missing Application.cfm file
Most likely you're missing the Application.cfm file on the same level that your login page is at, take a look at this page:
http://www.macromedia.com/support/dreamweaver/ts/documents/cf_login_error.htm Hope this helps, Jack
|
|
#3
October 26th, 2004, 03:10 PM
|
|||
|
|||
|
Is the query actually running and getting a result? Look in the debugging info to see. If it is, then the problem must be in the conditional logic somewhere.
__________________
Ask if you have a question, but also help answer questions that you have knowledge of! Thanks, Brian. How to Post a Question in the Forums
|
|
| Viewing: Dev Shed Forums > Programming Languages - More > ColdFusion Development > Login error |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
