Re: Get List of Session IDs

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: tomBond (tomBond.1hhqhq_at_mail.codecomments.com)
Date: 12/19/04 

Date: Sat, 18 Dec 2004 18:48:10 -0600

Hi.

This requires a little more effort, though not very much.
First, create new class and make there function for saving sessionid to
database and all the needed logic too to do the database stuff. Create
another function that deletes sessionid from database (takes sessid as
an parameter). Create on more function to get the list of sessionid's
which has been saved to database.
Now, the fun part:
In global.asax you have sub "On_SessionStart". Instantiate a new object
from the class you made for saving and deleting sessionid:s.
Get first the sessionid from the current session and pass it to the
sessionid saving method in your class.
In Global.asax is also sub "On_SessionEnd".
Do exact the same, only this time you use the function that deletes the
sessionid from the database.
Now you have sessionid:s stored in the database and they gets updated
and deleted dynamically as clients enter and leave your application.
To get a list of sessionid:s in the database you have to do a listing
page to get sessionid's listed. Page could be in the same application
that your clients uses, or it can be completely aside from that
application because the data exists in the database.

Hope this helps :)

-tom- 

--
tomBond
------------------------------------------------------------------------
Posted via http://www.codecomments.com
------------------------------------------------------------------------

Relevant Pages

  • Sessions
    ... I need to implement an audit trail on a existing Database. ... connection to the sql and the userid. ... for me to know the sessionid that each TADOConnection has to MSSQL? ...
    (borland.public.delphi.database.ado)
  • Re: session management with database: optimal parameters in php.ini
    ... On 3 mar, 19:00, Erwin Moller ... They all have a different sessionid, ... Make a htmlpage with 20 frames. ... ADODB (a database abstractionlayer) has a build-in sessionmanagement ...
    (alt.php)
  • Re: session management with database: optimal parameters in php.ini
    ... PHP will pass the sessionid to your functions you use in session_set_save_handler. ... Make a htmlpage with 20 frames. ... ADODB (a database abstractionlayer) has a build-in sessionmanagement module for database, ...
    (alt.php)
  • Re: Supporting multiple oracle versions in a trigger
    ... This is a very unscalable solution. ... Why would you do that in a database? ... > - Clients can add/modify their data collection requirements in minutes ... > - Clients can connect to the database with 3rd party sql tools and access ...
    (comp.databases.oracle.server)
  • Re: Poly Couples
    ... Essentially - different versions for different clients. ... insist that you use their existing database which is from a different ... vendor, and the structure is different than the one you use originally. ... characters would mark variable insertion place-holders in the SQL. ...
    (comp.object)