The first case would suffice. Could you let me know how you go about it?
Many thanks.
----- Original Message -----
From: "JL" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, October 18, 2000 5:47 PM
Subject: Re: [Re: Preventing Simultaneous Logins]
> when a user is logging in with user name "Login1" and another user is
trying
> to log in with the same user name, what do u want to do? kick out the
first
> user or stop the second user?
>
> The first case is easy. The second case is harder because you need to
clean
> up all the dead users in the table. You don't need to create another
table to
> do this if you are storing the client variables in the database.
>
> J
>
> "Peter Alexandrou" <[EMAIL PROTECTED]> wrote:
> > I can think of many similar solutions but they are all useless because
most
> > of the time users simply close their browsers or their sessions expire.
> >
> > Surely someone out there has tackled this problem successfully?
> >
> > ----- Original Message -----
> > From: "Pete Freitag" <[EMAIL PROTECTED]>
> > To: "CF-Talk" <[EMAIL PROTECTED]>
> > Sent: Wednesday, October 18, 2000 2:15 PM
> > Subject: RE: Preventing Simultaneous Logins
> >
> >
> > > 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]
> >
> >
> --------------------------------------------------------------------------
----------------------
> > 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]
>
>
> ____________________________________________________________________
> Get free email and a permanent address at http://www.netaddress.com/?N=1
> --------------------------------------------------------------------------
----------------------
> Archives: http://www.mail-archive.com/[email protected]/
> Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar
------------------------------------------------------------------------------------------------
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]
