Hi Bruce,
 
I did have the db open, but the table wasn't opened up. However, I closed access altogether and am still getting the same error.
 
- Gary
-----Original Message-----
From: Sorge, Bruce [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 07, 2001 11:04 AM
To: '[EMAIL PROTECTED]'
Subject: RE: Login based on Client Management - Major Weirdness!

Do you or someone else have the DB open?
-----Original Message-----
From: Houk, Gary [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 07, 2001 10:01 AM
To: '[EMAIL PROTECTED]'
Subject: RE: Login based on Client Management - Major Weirdness!

OK, here is the error I'm getting:
 
Error Occurred While Processing Request</TITLE></HEAD><BODY><HR><H3>Error Occurred While Processing Request
Error Diagnostic Information
ODBC Error Code = S1000 (General error)<P> [Microsoft][ODBC Microsoft Access Driver]
The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time.
 
I'm the only one working with this url. How can I modify my code so that this doesn't happen?
 
Thanks,
 
Gary
-----Original Message-----
From: Houk, Gary [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 07, 2001 10:34 AM
To: '[EMAIL PROTECTED]'
Subject: Login based on Client Management - Major Weirdness!

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>

Reply via email to