Hi Karl,
This may give you an idea or three ..
SELECT Registered.RegisterID, Registered.Login,
Registered.County, CGLOBAL.lvisit, CGLOBAL.cfidFROM
dbo.CGLOBAL INNER JOIN dbo.Registered ON
dbo.CGLOBAL.cfid = dbo.Registered.CFIDWHERE
(DATEDIFF(mi, dbo.CGLOBAL.lvisit, GETDATE())
I hate those type of errors because all
logic tells you everything is working its only when you suddenly hear the coin
hitting the ground (penny drop) that you slap yourself call yourself a numpty
and proclaim to the world that you should be ceremoniously whipped and paraded
in the streets
For anybody that cared or may be having
the same problem, it was the utility causing the problem!! Basically, it
dumped out to a sql table every 5 minutes the number of sessions. Because it
accessed the session to get the information, it updated the last accessed
date/time for the session
Hello,
I've
recently upgraded to CFMX6.1 and have been using the utility from the CFDJ
magazine that shows how many live and expired sessions and currently residing
in memory for any given application.
I noticed
that my number of active sessions continues to grow - ev
