p2p.wrox.com Forums

Need to download code?

View our list of code downloads.


  Return to Index  

proasp_howto thread: AW: Session variables vs. SQL Server 7.0


Message #1 by "Neethling, Dirk HTC/DE/EIC" <Dirk.Neethling2@h...> on Tue, 13 Mar 2001 14:05:12 +0100
Hello Tom,
When the user leaves the site, or the client crashes or the server goes
down, or the user simply closes the client, how do you decide the user 
has
left and then remove the user + GUID from the SQL table?
Dirk

> -----Urspr=FCngliche Nachricht-----
> Von:	Tom Kim [SMTP:tkim@a...]
> Gesendet am:	Montag, 12. M=E4rz 2001 22:29
> An:	How To
> Betreff:	RE: Session variables vs. SQL Server 7.0
>
> 	Tom, currently with my ASP Classic (Kind of like Coke Classic) I use
> SQL to store any "session" values.  When the user first hits the 
site, I
> insert a new row into a simple SQL table with a Primary key that is a 
GUID
> and a Text column to store everything else, and I do mean everything. 
 I
> don't use any session variables in my sites, but I do use a few
> application level values.
> =09
> 	  I then carry this GUID that was assigned to that user/session and
> pass that along with the user either with a hidden <input> or in the
> response header. 
>

  Return to Index