Update Records

[Silvinho]

I'm using the script below to update a record when the page loads to indicate if the user is logged on and the time they logged on. but i keep getting error messages on the 'objComm.Execute()' line. Im using the same script in the Global.Asa to update a users status but this never works on logout.

Dim objComm
Set objComm = Server.CreateObject("ADODB.Command&quot

objComm.ActiveConnection = MM_connChat_STRING
objComm.CommandText="UPDATE Members SET LoggedIn = 'Yes', LastLoginDate = '" + Replace(LoginDate, "'", "''&quot + "'" "WHERE Username = '" + Replace(rsEdit__MMColParam, "'", "''&quot + "'"

objComm.Execute()
Set objComm = Nothing

 

[lobstah]

what error do you get?

 

[Silvinho]

Sometimes it works as it is but in Global.asa it doesn't work. I seem to get different error messages when i change the objComm.Execute()line. is that line line the correct syntax?

All the code works correctly when i use it on a network database connection but when i upload to a remote server i get some errors such as the global.asa not updating