Hi Steve yep trying to avoid using cookies. I want to pass people around the private part of the site with security set from an entry in tblUser.
Mike ----------------- Doh, nevermind, your not using cookies to set the login. *takes another look ______________________ steve oliver atnet solutions, inc. http://www.atnetsolutions.com -----Original Message----- From: Steve Oliver [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 4:06 PM To: CF-Talk Subject: RE: Password Protection - whats wrong with this Yeah, your using cflocation, which will not set cookies. Try using <cfheader name="REFRESH" value="0; url=index.cfm"> Or you could use a meta tag, or a javascript redirection. ______________________ steve oliver atnet solutions, inc. http://www.atnetsolutions.com Oops! I've taken out the HTML so it won't appear as a web page Mike Hi I can't get this to work.It looks for data from SQL7 table called tblUser I've been fiddling with it but obviously missing something. Can anyone spot the error --------------------------------- <CFIF IsDefined("URL.Login")><!--- ---> <CFQUERY name="getUser" datasource="CFSQL"> SELECT ID, Password FROM tblUser WHERE ID='#Form.userName#' AND password='#Form.password#' </CFQUERY> <!--- ---> <CFIF getUser.RecordCount GT 0> <CFSET SESSION.loggedIn="yes"> <CFLOCATION url="index.cfm"> <CFELSE> <CFLOCATION url="login.cfm?failed=yes"> </CFIF> </CFIF> <CFIF IsDefined("URL.failed")> <CFSET errMsg="Login Failed, Please Try Again"> <CFELSEIF IsDefined("URL.notLoggedIn")> <CFSET errMsg="User Not Logged In"> <CFELSE> <CFSET errMsg="Please Login Below"> </CFIF> <CENTER><BR><H3><B>Welcome to NZERN Members Website</B></H3><BR><H4> <!--- gives error message on web page ---> <CFOUTPUT> #errMsg# </CFOUTPUT> </H4><BR><BR><!--- form to login ---> <FORM action="login.cfm?login=yes" method="post"><!--- enter user name---> UserName <INPUT type="text" name="userName"><BR><!--- enter password ---> Password <INPUT type="password" name="password"><BR> <INPUT type="submit" value=" Login "> -------------------- Error Diagnostic Information An error occurred while evaluating the expression: #Form.userName# Error near line 23, column 18. ---------------------------------------------------------------------------- ---- Error resolving parameter FORM.USERNAME The specified form field cannot be found. This problem is very likely due to the fact that you have misspelled the form field name. The error occurred while processing an element with a general identifier of (#Form.userName#), occupying document position (23:17) to (23:31). Date/Time: 02/08/02 09:55:00 Browser: Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0) Remote Address: 210.86.52.9 Query String: login=yes ------------------------------------------- thanks in advance for any help (I'm a newbee) Mike ---------------------------------------------------- NZERN Mail: PO Box 9000, Christchurch (03) 338-5451 E-mail: [EMAIL PROTECTED] http://www.bush.org.nz ---------------------------------------------------- ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
