|
 |
asp_databases thread: Error appear at the server not the client
Message #1 by "Amjad Ali" <amjad2000@h...> on Fri, 30 Mar 2001 23:09:55
|
|
I have a discussion forum, when one user delete an item and another user
is accessing that site at the same time try to access that item an error
happen and a message displayed on the server.
Having said that, is there a way to get the browser refreshed on all the
open session? And how can I eliminate the error popping up on the server
and having instead some indication displayed on the client. Thanks.
Message #2 by "Markus Hain" <kill@g...> on Fri, 30 Mar 2001 23:19:40
|
|
> I have a discussion forum, when one user delete an item and another user
> is accessing that site at the same time try to access that item an error
> happen and a message displayed on the server.
> Having said that, is there a way to get the browser refreshed on all the
> open session? And how can I eliminate the error popping up on the server
> and having instead some indication displayed on the client. Thanks.
Hi
Sounds like you need to use "row locking", in sql use "set nocount on;"
then execute your insert, update etc. This will actually prevent two
people accessing the same record at the same time. To get your browser
refreshed i would just use the meta tag for refreshing, and put an include
in your pages to check whether the session is still valid. What error is
popping on the server ?
Markus
|
|
 |