First thing I'd check is what GetUser.RecordCount returns, you might be getting more than one record and hence the else code block will run.
Ade -----Original Message----- From: (s) Fiona Tope [mailto:[EMAIL PROTECTED] Sent: 08 March 2004 20:08 To: [EMAIL PROTECTED] Subject: RE: [ cf-dev ] Upload Access to cfdeveloper site How come it works in my local machine with exactly the same codes and exactly the same database contents? When type in user name and password, the " Re-prompt for a valid username and password " codes are executed and show the "Sorry,.... " message. ********** Form login form template ******* <CFFORM ACTION="#CGI.SCRIPT_NAME#" NAME="LoginForm" METHOD="POST"> <!--- Make the UserLogin and UserPassword fields required ---> <INPUT TYPE="Hidden" NAME="UserLogin_required"> <INPUT TYPE="Hidden" NAME="UserPassword_required"> <!--- Use an HTML table for simple formatting ---> <TABLE BORDER="0" align="center"> <TR class="fm"> <TH height="37" COLSPAN="2">Please Log In</TH> </TR> <TR> <TH width="136" height="38" align="right" class="fm"> UserID:</TH> <TD width="262" class="fm"> <!--- Text field for "Admin UserID" ---> <cfinput class="text" type="Text" name="UserLogin" size="5" value="" maxlength="20" required="Yes" validate="integer" message="Please enter your User ID."> </TD> </TR><TR> <TH height="51" align="right" class="fm">User Password:</TH> <TD class="fm"> <!--- Text field for "Admin Password" ---> <CFINPUT class="text" TYPE="Password" NAME="UserPassword" SIZE="20" VALUE="" MAXLENGTH="25" REQUIRED="Yes" MESSAGE="Please enter your User Password to gain access."> ******* From loginCheck template ******** <CFIF GetUser.RecordCount EQ 1> <CFSET SESSION.Auth = StructNew()> <CFSET SESSION.Auth.IsLoggedInApp = "Yes"> <CFSET SESSION.Auth.fname= GetUser.fname> <CFSET SESSION.Auth.lname = GetUser.lname> <CFSET SESSION.Auth.user_login = GetUser.user_login> <CFSET SESSION.Auth.user_password = GetUser.user_password > <CFLOCATION URL="index.cfm"> <!--- Re-prompt for a valid username and password ---> <CFELSE> <TR> <TD ALIGN="right"> Sorry, that username and password are not recognized. Please try again. </TD> </TR> -----Original Message----- From: Adrian Lynch [mailto:[EMAIL PROTECTED] Sent: Sun 07/03/2004 21:47 To: [EMAIL PROTECTED] Cc: Subject: RE: [ cf-dev ] Upload Access to cfdeveloper site -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
