I need to control which users are logged into my xojo webapp.
I’m currently using a boolean field in mysql, but when the user close browser i can’t set the field to False.
there is a better way to do this?
On session.Close
DIM DB As NEW MySQLCommunityServer
'....conection code here
SESSION.UserID
DB.SQLExecute "UPDATE myUSERS SET ONLINE=0 WHERE myUSERS .IF=" + session.UserID 'HERE I RECEIVE AN NIL OBJECT ERROR
DB.close