I just removed the query that deletes the user from the database and then just reset the vars on the application file page when the user is not logged in. It seems to be working now.
Thanks for all your help :-)
- Gary
-----Original Message-----
From: Billy Cravens [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 07, 2001 11:23 AM
To: [EMAIL PROTECTED]
Subject: Re: Login based on Client Management - Major Weirdness!
Sounds like a contention or time out issue. Are you maintaining the
connection? How about exclusive access? I'd dig around in the ODBC
settings (both in the control panel and in CF Admin) to see if you can
find any strangeness.
Additionally, the CDATA table is going to get hit internally by
ColdFusion, so in addition to HTTP requests, that's where your multiple
DB access is likely coming from.
--
Billy Cravens
HR Web Development, Sabre
[EMAIL PROTECTED]
> "Houk, Gary" wrote:
>
> Hi eveyone,
>
> I'm woking on a new login and getting a VERY strange error. Here is a
> breakdown:
>
> - user logs in
> - page times out
> - when being redirected to the login page, part of the login.cfm file
> is displayed - THE ACTUAL RAW CODE!!!
> - if the user hits refresh one more time they are then sent to the
> login page and it is displayed as it should be
>
> This only happens in IE - Netscape works fine!!! If there is a better
> way of rewriting this code please share!!!
>
> Thanks in advance,
>
> - Gary
>
>
> --------------------------------------------------------------------------------------------------------------------
>
> (application.cfm file)
>
>
>
> <CFAPPLICATION NAME="RSSC"
> CLIENTMANAGEMENT="Yes"
> SESSIONMANAGEMENT="Yes"
> SETCLIENTCOOKIES="No"
> CLIENTSTORAGE="client_storage_local">
>
> <!--- Set Global Variables --->
> <CFSET APPLICATION.DSN="rssc">
> <CFSET APPLICATION.FACE="arial">
> <CFSET APPLICATION.TIMEOUT="2">
> <CFSET APPLICATION.TIMESPAN="s">
> <!--- H = hour, n = minute, s = second --->
>
> <!--- SET DEFAULT PARAM FOR LOGGEDIN VARIABLE --->
>
> <CFPARAM NAME="CLIENT.LOGGEDIN" DEFAULT="FALSE">
> <CFIF CLIENT.LOGGEDIN IS "FALSE">
>
> <!-- IF THE USER HAS NOT LOGGED IN, AUTOMATICALLY REDIRECT THEM TO THE
> LOGIN PAGE -->
>
> <CFSET PATH=GETDIRECTORYFROMPATH(#CGI.CF_TEMPLATE_PATH#)>
> <CFIF (CGI.CF_TEMPLATE_PATH IS NOT "#path#login.cfm")
> AND (CGI.CF_TEMPLATE_PATH IS NOT "#path#validate.cfm")>
>
> <CFLOCATION URL="http://c0157/security/login.cfm" ADDTOKEN="Yes">
>
> </CFIF>
> </CFIF>
>
>
>
>
> I'm guessing that this next part of the application.cfm file is what
> is causing the code to be shown but I'm not sure where.
>
>
>
>
> <!--- TEST TO SEE IF SESSION HAS TIMED OUT AFTER A SUCCESSFUL LOGIN
> --->
>
> <CFIF CLIENT.LOGGEDIN IS "true">
>
> <CFIF DATEDIFF("#application.timespan#", CLIENT.LASTVISIT, NOW()) GTE
> APPLICATION.TIMEOUT>
>
> <!--- IF THE USER HAS TIMED OUT, DESTROY THEIR SESSION BY DELETING
> THEM FROM THE DATABASE --->
>
> <CFQUERY NAME="deleteuser" DATASOURCE="client_storage_local">
> delete from cdata
> where cfid='#cfid#:#cftoken#'
> </CFQUERY>
>
> <!--- RESET THE LOGGEDIN VAR TO BE FALSE --->
>
> <CFSET CLIENT.LOGGEDIN = FALSE>
>
> <!--- REDIRECT THEM BACK TO THE HOMEPAGE --->
>
> <CFLOCATION URL="http://c0157/security/login.cfm" ADDTOKEN="yes">
>
> </CFIF>
> </CFIF>
-------------------------------------------------------------------------
This email server is running an evaluation copy of the MailShield anti-
spam software. Please contact your email administrator if you have any
questions about this message. MailShield product info: www.mailshield.com
-----------------------------------------------
To post, send email to [EMAIL PROTECTED]
To subscribe / unsubscribe: http://www.dfwcfug.org
