Wrox Home  
Search P2P Archive for: Go

  Return to Index  

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

  Return to Index