Keep a log of when people login, and when they log out (could get very
large, but you could purge it daily). Then when someone logs in do the
following...
SELECT username FROM audit_table
WHERE
username = '#form.username#' AND
timestamp > #DateAdd("n", -30, Now())#
ORDER BY action
That will see if the user has been around in the last half hour
Action could be a boolean field 1 being login 0 being logout
<cfif audit.recordcount>
<cfif audit.action>
already logged in <cfabort>
</cfif>
</cfif>
login...
The problem with this entire process, is that there is no destructor called
when a session disappears, or times out.
______________________________________________
Pete Freitag ([EMAIL PROTECTED])
CFDEV.COM / NETDesign Inc.
ColdFusion Developer Resources
http://www.cfdev.com/
-----Original Message-----
From: Peter Alexandrou [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 17, 2000 7:37 PM
To: CF-Talk
Subject: Preventing Simultaneous Logins
Hi guys,
I'm new to the mailing list and have a quick question for y'all.
What is the best way to prevent a userID being logged in twice i.e. someone
logs in with "login1" and then another user logs in with the same ID.
Thanks,
Peter Alexandrou
Technical Leader
tapestry communications : www.tapestry.net.au
phone : 0411 445 111
e-mail : [EMAIL PROTECTED]
----------------------------------------------------------------------------
--------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a
message with 'unsubscribe' in the body to [EMAIL PROTECTED]
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
