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
Not sure about cfdeveloper but you could try debugging the code. Step through
it with cfabort and output details to help you find the problem. Start at the login
form and move forward from there.
If you post some code we might spot something :O)
Ade
-----Original Message-----
From: (s) Fiona Tope [mailto:[EMAIL PROTECTED]
Sent: 07 March 2004 20:33
To: [EMAIL PROTECTED]
Subject: [ cf-dev ] Upload Access to cfdeveloper site
Hi there,
I exported the SQL Server database into Access and then uploaded to the
cfdeveloper site, but the login does not recognize my usual username and password - it
would however returned the pre-set error message to prompt the user for valid login
details. It works in my local machine connects to SQL Server database. The database
contents are the same as in Access.
Any idea!?
Cheers,
Fiona
--
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]
