i tried copying the code you had sent me, but now after trying to login, it gets sent to an error page, i have not inserted anything into the sql database, so hence there are no records of any members, so if i type in a member should it not state that i am an unauthorsed user instead of going to an error page!
sanjay
From: [EMAIL PROTECTED] Reply-To: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Subject: RE: [ cf-dev ] login tutorial Date: Tue, 9 Mar 2004 15:14:42 +0000
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]
_________________________________________________________________
It's fast, it's easy and it's free. Get MSN Messenger today! 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]
