THanks all. Here is my application.cfm code as it is. It may not be pretty. In a
perfect world I want to check to see the sessionid variable is active(aka the user is
already here). If so then update a table. If not i want it to find a number and
create one(sessionid). Then add it to the table.
Thanks
<!---Application.cfm page. Sets variables--->
<CFAPPLICATION NAME="TCOM"
SESSIONMANAGEMENT="YES"
SESSIONTIMEOUT="#CREATETIMESPAN(0,0,30,0)#">
<CFIF NOT ISDEFINED('SESSION.USER_NAME')>
<CFPARAM NAME="SESSION.USER_NAME" DEFAULT="na">
<CFPARAM NAME="SESSION.NAME" DEFAULT="na">
<CFPARAM NAME="SESSION.SECUREDGROUP" DEFAULT="na">
<CFPARAM NAME="SESSION.SESSIONID" DEFAULT="na">
<CFPARAM NAME="SESSION.LOGIN" DEFAULT="na">
<CFPARAM NAME="SESSION.ORGROUP" DEFAULT="na">
<CFSET DIFF = 'NO'>
<CFLOOP CONDITION="DIFF EQ 'NO'">
<CFSET IDNUMBER= #RANDRANGE(10000, 10000000)#>
<CFQUERY NAME="ID" DATASOURCE="PCNET">
SELECT IDNUMBER
FROM tblsessions
WHERE IDNUMBER = #IDNUMBER#
</CFQUERY>
<CFIF #ID.RECORDCOUNT# IS 0>
<CFSET DIFF = 'Yes'>
</CFIF>
</CFLOOP>
<CFLOCK TIMEOUT="30" NAME="#SESSION.USER_NAME#">
<CFSET SESSION.USER_NAME="#IDNUMBER#">
</CFLOCK>
<CFLOCK TIMEOUT="30" NAME="#SESSION.SESSIONID#">
<CFSET SESSION.SESSIONID="#IDNUMBER#">
</CFLOCK>
<CFSET TIMET= TIMEFORMAT(NOW(), 'HH:MM:SS')>
<CFSET DATED= DATEFORMAT(NOW(), 'mm-dd-yyyy')>
<CFQUERY DATASOURCE="PCNET" NAME="INSERT">
INSERT INTO tblsessions(TIMEIN, IDNUMBER, IPADDRESS, DATED)
VALUES('#VARIABLES.TIMET#', #SESSION.USER_NAME#, '#REMOTE_ADDR#',
'#VARIABLES.DATED#')
</CFQUERY>
<CFELSE>
<CFSET TIMEL= TIMEFORMAT(NOW(), 'HH:MM:SS')>
<CFQUERY NAME="UPDATE" DATASOURCE="PCNET">
UPDATE tblsessions
SET LASTTIME ='#VARIABLES.TIMEL#'
WHERE IDNUMBER= #SESSION.USER_NAME#
</CFQUERY>
</CFIF>
<CFIF ISDEFINED("Cookie.CFID") AND ISDEFINED("Cookie.CFTOKEN")>
<CFSET CFID_LOCAL = COOKIE.CFID>
<CFSET CFTOKEN_LOCAL = COOKIE.CFTOKEN>
<CFCOOKIE NAME="CFID" VALUE="#cfid_local#">
<CFCOOKIE NAME="CFTOKEN" VALUE="#cftoken_local#">
</CFIF>
>>> [EMAIL PROTECTED] 01/17/01 11:57AM >>>
MM Michael,
Can we see the application.cfm code? And/Or a link to the offending page.
BB,
--K
-----Original Message-----
From: Michael Ross [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 17, 2001 8:53 PM
To: CF-Talk
Subject: Re: Sessions
opps I am sorry to everyone. It was pointed to me that my message might be
viewed differently than I intended. My message didn't really show that I do
have a problem. My problem is that on the first call of the page my
sessionid is 49494949 (or eight numbers only). The second time any page is
called I get the one below tcom_686_#########. Why is it changing on me I
don't want it too.??How is that generated anyway.
Sorry to sound rude before...
Thanks
>>> [EMAIL PROTECTED] 01/17/01 12:06PM >>>
I have an app that sets a session id. The first time you call any
page(which uses application.cfm)it sets a number and works great. If i
refresh the page I get a var that looks like this tcom_686_####### where
tcom is the application name, 686 is a number that is being incremented
everytime I call a new session. and #### changes randomly. Anyone ever seen
this???
Thanks
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
