I have a framed website.
I plan to include in default.asp a routine to check if the annual
subscription is due from the records in the People table.
If so, then the routine would send emails to those who are due and update
the table that this had been done, so that it is only done once.
If session 1 is doing just this, session 2 (and 3 and n) could be doing the
same thing.
Does adLockPessimistic stop this duplication? It seems that this only stops
the table being updated by session 2; it doesn't stop session 2 querying the
table, seeing that subscriptions are due, then updating the table and
sending
the same emails as session 1 when it unlocks the table.
Should I approach this requirement by a different method?
Posted Via Usenet.com Premium Usenet Newsgroup Services
----------------------------------------------------------
** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
----------------------------------------------------------
http://www.usenet.com