Disregard. I figured it out. BN
> Howdy all - > > So I thought I had this login thing worked out, but after an hour of > pulling out my hair I'm stumped. > > In short, I can fill out the login form and submit it. It checks the > DB just fine and CF logs you in just fine. It's when you reach the > bottom of the act_login.cfm template it fails when the CFLOCATION > sends you back where you came from. > > Here's the code out line. > > > Code included for: Application.cfc and act_Login.cfm > > (notes for app flow are in *****NOTES**** in the code) > > First I'll show the Application.cfc so you can see how that's set up. > In short it sets you up as a guest that is a record in the db if you > are not logged in. (for foriegn key needs.) No matter what I try, when > the CFLOCATION tag fires in the act_Login.cfm template, the <cfquery > name="GetNoAuthGuest" in the application.cfc fires. Thus that means > <cfif GetAuthUser() eq ""> above the query is evaluating to true. ie: > login data was lost in the CFLOCATION. > > In the act_login.cfm file it just takes your data and logs you in or > fails. The DESTINATION var is passed in from where you came from as a > URL so you can get back there. ie: DESTINATION = "http://www.r00t. > com/FileShare/index.cfm" > > Also, the queries have been obscured. > > Thank you to everyone who can give a minute to look this over, I hope > I did a decent job at giving everthing you need to review. > > ---------------------------------------------------------- > ---------------------------------------------------------- > > Application.cfc - (brief) > ---------------------------------------------------------- > <cfset this.name="ThisIntranet"> > <cfset this.sessionmanagement="yes"> > <cfset this.SetClientCookies="no"> > <cfset this.loginstorage="session"> > <cfset this.applicationTimeout=CreateTimeSpan(0,12,0,0)> > <cfset this.sessionTimeout=CreateTimeSpan(0,4,0,0)> > > <cffunction name="onSessionStart" returntype="void"> > > <cfif GetAuthUser() eq ""> > <!--- if no user info is passed from IE's ActiveDirectory > connect > ---> > <cfif cgi.AUTH_USER eq ""> > <!--- log user in as guest---> > <!--- get guest account ---> > > ****************RUNS AS IT SHOULD THE FIRST TIME, BUT RUNS THIS EVEN > AFTER LOGIN (CFLOCATION relocation in act_login.cfm) > *********************** > > <cfquery name="GetNoAuthGuest" > dataSource="#request.DATASOURCE#"> > SELECT DATA > FROM TABLE > WHERE UPPER(E.LAST_NAME) = 'CFL GUEST' > </cfquery> > <cflogin> > <cfloginuser name="#GetNoAuthGuest.DATA#" > Password="cfl-guest" > roles="GUEST"> > </cflogin> > <cfelse> > <!--- if user info is passed from IE's ActiveDirectory > connect > ---> > <CFSET AUTH_USER = > ListLast(Replace(Replace(UCASE(cgi.AUTH_USER), > "\",",","ALL"),"/",",","ALL"))> > > <cfquery name="loginQuery" > dataSource="#request.DATASOURCE#"> > SELECT DATA > FROM TABLE > WHERE USER_NAME = '#AUTH_USER#' > </cfquery> > > <cfif loginQuery.RecordCount neq 0> > <cflogin> > <cfloginuser name="#loginQuery.DATA#" > Password="#loginQuery. > password#" roles="#loginQuery.ROLE#"> > </cflogin> > <cfelse> > <!--- log user in as guest---> > <!--- get guest account ---> > <cfquery name="GetGuest" > dataSource="#request.DATASOURCE#"> > SELECT DATA > FROM TABLE > WHERE UPPER(E.LAST_NAME) = 'CFL GUEST' > </cfquery> > <cflogin> > <cfloginuser name="#GetGuest.DATA#" > Password="cfl-guest" > roles="GUEST"> > </cflogin> > </cfif> > </cfif> > </cfif> > > </cffunction> > -------------------------------------------------------------------- > -------------------------------------------------------------------- > > act_Login.cfm - > -------------------------------------------------------------------- > <cfparam name="destination" default=""> > > <cfif J_USERNAME IS "" OR J_PASSWORD IS ""> > <cfoutput> > <h2>You must enter text in both the User Name and Password fields. > </h2> > </cfoutput> > <cfinclude template="dsp_LoginForm.cfm"> > <cfabort> > > <cfelse> > > <cfquery name="loginQuery" dataSource="#request.DATASOURCE#"> > SELECT DATA > FROM TABLE > WHERE USER = '#J_USERNAME#' > AND PASSWORD = '#J_PASSWORD#' > </cfquery> > > <cfif loginQuery.RecordCount neq 0> > <cflogout> > <cflogin applicationtoken="#application.applicationname#"> > <cfloginuser name="#loginQuery.DATA#" Password = > "#loginQuery. > PASSWORD#" roles="#loginQuery.ROLE#"> > </cflogin> > <cfelse> > <cfoutput> > <H2>Your login information is not valid.<br>Please Try > again</H2> > </cfoutput> > <cfinclude template="dsp_LoginForm.cfm"> > <cfabort> > </cfif> > > </cfif> > > <cfif destination neq ""> > ************THIS IS WHERE IT FAILS TO PASS THE LOGIN INFO ?? > *********************** > <cflocation url="#destination#" addtoken="Yes"> > <cfelse> > <cflocation url="index.cfm" addtoken="Yes"> > </cfif> ------------------------------------------------------------------------------- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:263227 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
