hi,

i am using asp and sql server. i can stored login time,username,session id in database.how can i stored first user and disply message ie alert "already login,pls log another username".

how i can disply this message.
how i can block multiple same user name.

pls give me immediate reaction.

because i have try so much but i cant successful.


thank

hi,
Try with this method,
what you can do, first when user login just put a flag true in the same user database true,
if the same time anyone login, just check login flag true or flase, if it is true, you can give a error message. else success login.
When the user logout, you have to set flag flase everytime. if they did not logout, just clear flag afetr some hours.

surendran
(Anything is Possible)

HI,
Thanks for given idea.

But i can used status in database.when user login then status is "Y" and logout then "N".

I try to block status in this query.

qq3 = "select LoginHistoryStatus = 'Y' From LoginHistory Where LoginHistorySessionID='"&Request.form ("name") & "'"
     'response.write qq3
     Set rs=con.Execute(qq3)
     If not rs.EOF then
     if LoginHistoryStatus = "Y" then
     Response.write "User r already Logged in"
     End if
     end if

Loginhistory is table name .but it cant work.so any problem pls slove this.

thanks

Hi,
Try with this code, But this is not going to check your user name correct or not,
after this if he login successfully, set LoginHistoryStatus ='Y' then only other user can not login same name.

qq3 = "select * From LoginHistory Where LoginHistorySessionID='"&Request.form
("name") & "' and LoginHistoryStatus = 'Y' "
Set rs=con.Execute(qq3)

if rs.RecordCount => 1 then
Response.write "User r already Logged in"
else
end if

surendran
(Anything is Possible)
http://ssuren.spaces.msn.com