fyi ~ i put a easy lil snippet on www.dwfaq.com that you add to your login that brings you back to the login page with any error display if the login is incorrect If you havent checked out the snippets there you should, great little resource
----- Original Message ----- From: "Bruce Sorge" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Monday, January 13, 2003 12:08 PM Subject: Re: How can I redirect a user? > There are several login tags available, but the best way is to just have a > page that loggs the user in. I normally use a page called Login.cfm. All > this page does is, checks the users information that they posted on the > login form against the database, and if they are valid, I set some > application level variables and the like, then redirect them to the > appropriate page. If they do not have a account or did not enter their > infrmation correctly, they are redirected to the login page with a message > of what they did wrong. > > > So for instance, the code could look like this: > > Validate the user againstthe database > > <cfquery datasource="#Application.DSN#" Name="qry_CheckUser"> > Select Fname, Lname, UserID, Password > From Users > Where #TRIM(Users.UserID = Form.UserID)# AND #TRIM(Password = > Form.Password) > </cfquery> > > Check to see if the information is valid > > <cfif (qry_CheckUser.Recordcount) IS "1"> > set application, session or client variables here and redirect them with > cflocation > > <cfelse> > Set error message to display and send them back to the login page displaying > the error message. > > </cfif> > > This is a very simplified login routine. Like I said, there are several out > there on the Developers Exchange. Just do a search for Login. > > ----- Original Message ----- > From: "Scott Wilhelm" <[EMAIL PROTECTED]> > To: "CF-Talk" <[EMAIL PROTECTED]> > Sent: Monday, January 13, 2003 10:52 AM > Subject: How can I redirect a user? > > > > I'm setting up authentication against a database, and I have the form > > data going to a seperate page that I want users not to see (just a > > preference of mine)...Once the page is done processing, I want to push > > the users off to a different page...How do I do that? Are there any CF > > tags for it? > > > > Thank you, > > > > Scott > > > > PS. I'm very wet behind my ears, so if there's some tricks for > > authenticating against a db, please feel free to tell me. > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
