one thing, for some reason they're relying on javascript to do a redirect,
and display an annoying 'welcome' message. dump that bit, and replace with
a cflocation or stick in some tracer code to show you if it reaches that.
how about this for a modified version:
<cfquery name="qVerify" datasource="userLogin">
SELECT user_name, user_pass
FROM tblAdmins
WHERE user_name = '#user_name#'
AND user_pass = '#user_pass#'
</cfquery>
<cfdump var="#qVerify#">
<cfif qVerify.RecordCount>
<!--- This user has logged in correctly, change the value of the
session.allowin value --->
<cfset session.allowin = "True">
<!--- Now redirect to "members_only.cfm" --->
Redirect to members only <!--- commented out the cflocation just now
--->
<!--- <cflocation url="members_only.cfm"> --->
< cfelse>
<!--- this user did not log in correctly, alert and redirect to the
login page --->
Nothing found <!--- commented out the cflocation just now --->
<!--- <cflocation url="page.cfm?error=notfound"> --->
</cfif>
At least this way you should be able to see what you're getting back from
the query, and which part of your if-else statement executes.
Duncan Cumming
IT Manager
http://www.alienationdesign.co.uk
mailto:[EMAIL PROTECTED]
Tel: 0141 575 9700
Fax: 0141 575 9600
Creative solutions in a technical world
----------------------------------------------------------------------
Get your domain names online from:
http://www.alienationdomains.co.uk
Reseller options available!
----------------------------------------------------------------------
----------------------------------------------------------------------
"sanjay sidar"
<[EMAIL PROTECTED] To: [EMAIL PROTECTED]
tmail.com> cc:
Subject: RE: [ cf-dev ] login tutorial
09/03/2004 14:45
Please respond
to dev
hey guys i have this code copied from: http://tutorial8.easycfm.com/
and i cant seem to get anything displayed, would anyone be able to tell me
whats wrong
<cfquery name="qVerify" datasource="userLogin">
SELECT user_name, user_pass
FROM tblAdmins
WHERE user_name = '#user_name#'
AND user_pass = '#user_pass#'
</cfquery>
<cfif qVerify.RecordCount>
<!--- This user has logged in correctly, change the value of the
session.allowin value --->
<cfset session.allowin = "True">
<!--- Now welcome user and redirect to "members_only.cfm" --->
<script>
alert("Welcome user, you have been successfully logged in!");
self.location="/members_only.cfm";
</script>
< cfelse>
<!--- this user did not log in correctly, alert and redirect to the
login page --->
<script>
alert("Your credentials could not be verified, please try
again!!!");
self.location="Javascript:history.go(-1)";
</script>
</cfif>
_________________________________________________________________
Use MSN Messenger to send music and pics to your friends
http://www.msn.co.uk/messenger
--
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]
--
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]
