set a time out on a value

[slider]

Hey all is it possible to tell a value in a db to expire after a certain amount of time?

for example when a user logs in it sets a value to 1 and after 10 mintues it needs to be set to 0

any ideas?

im using sql 2000 server and vb asp thanks

[ck9663]

Hey all is it possible to tell a value in a db to expire after a certain amount of time?

for example when a user logs in it sets a value to 1 and after 10 mintues it needs to be set to 0

any ideas?

im using sql 2000 server and vb asp thanks

if your application is a browser-based application, i would assume this is for login tracking...create a unique session id every successful login...keep track of that id in a SESSIONTABLE (of some sort)...on top of every page, run a function that accepts that id, check a LASTACCESSDATE field. if datediff(mm, getdate(), LASTACCESSDATE) >= 10, update the SESSIONTABLE.status = 'T' (for timeout) and let this function return a failed flag...on the ASP page, if the function returned a failed flag, then it's timeout...redirect your page to a "SESSION TIMEOUT" page...

if the datediff(mm, getdate(), LASTACCESSDATE) < 10, update the LASTACCESSDATE with getdate(), meaning the last time your application was used is the current date-time....then let this function return a success flag...on your ASP page, if the function returned a success flag, proceed to your page...

make sense?