multiple updates

Results 1 to 2 of 2

Thread: multiple updates

  1. #1
    Join Date
    Dec 1969

    Default multiple updates

    &nbsp;<BR> I am developing a chat application using asp and access database. When admin is not online in the chat room then all the users should be logged out from chat after 30 seconds. So i update a field for each user in the database when a user logs out. <BR><BR> Now since all the users are logging out at the same time after 30 seconds its not updating the field in the database. it works fine for one user.<BR><BR> can anyone tell me a solution for this.

  2. #2
    Join Date
    Dec 1969

    Default RE: multiple updates

    ok known facts are:<BR><BR> Admin not logged in<BR>Log out after 30 sec<BR><BR>So<BR><BR>If Not (AdminState= "logon") Then <BR> Sql = "Update logintable Set loggedin = 0 Where loggedin = 1"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts