[dba-SQLServer] 2-minute window

how about a new table that stores the temporary grabs.  in that table is a 
column called "expire_datetime".  when that table is populated, the 
"expire_datetime" is set to 2 minutes into the future.  A sql server agent 
that runs every two minutes can remove records that have expired.



>From: Arthur Fuller <artful at rogers.com>
>Reply-To: dba-sqlserver at databaseadvisors.com
>To: dba-sqlserver at databaseadvisors.com
>Subject: [dba-SQLServer] 2-minute window
>Date: Wed, 08 Dec 2004 17:57:01 -0500
>
>I have to create a situation in which the customer (web) selects an item 
>and I want to put a 2-minute limit on the grab, so if the user fails to 
>click Submit within two minutes the grab is cancelled.
>
>I really have no idea how to implement this. In keeping with my general 
>predilections, then I would much prefer that it occur in the db not in the 
>front end, not least because in this app there will be both an Access FE 
>and a web FE, so I would like both to fire a sproc or something to effect 
>this 2-minute window.
>
>Maybe I could write the grabs to a new table, but I would need to observe 
>that in the real table the quantity is 10 and in the temp table 4 grabs are 
>currently active, i.e. there are only 2 items remaining... which could 
>change if the 2-minute window expires or the user clicks Cancel.
>
>I'm quite unsure how to go about this. Any advice? As stated above, I would 
>much prefer to do it in the BE than the FEs.
>
>Arthur
>
>>
>
>
>--
>No virus found in this outgoing message.
>Checked by AVG Anti-Virus.
>Version: 7.0.289 / Virus Database: 265.4.7 - Release Date: 12/7/2004
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>