quote:

---

This doesn't appear to work in mysql. In the who's online mod, in onine2.asp, is the following code

    if rsWho.eof or rsWho.bof then
	
	       Set objRS2 = Server.CreateObject("ADODB.Recordset")
	       objRS2.Open "FORUM_ONLINE", objConn, 1, 2, 2
           objRS2.AddNew
	       objRS2("UserID") = User
	       objRS2("Status") = "LOGIN"
	       objRS2("DateCreated") = fDate
	       objRS2("CheckedIn") = CheckInTime
	       objRS2("M_BROWSE") = Location
	       objRS2.Update
		   objRS2.close
	 else
		strSql = "UPDATE FORUM_ONLINE SET M_BROWSE =  '" & Location & "' , DateCreated = '" & fDate & "' WHERE UserID = '" & User & "'"
		my_Conn.Execute (strSql)
	end if

Using mysql it fails with the following error
3219 | Operation is not allowed in this context.
if you change the code to

    if rsWho.eof or rsWho.bof then
			on error resume next
	       Set objRS2 = Server.CreateObject("ADODB.Recordset")
	       strSQL =  "INSERT INTO " & strTablePrefix & "ONLINE ( UserID,Status,DateCreated,CheckedIn,M_BROWSE) VALUES ("
		   strSql = strSQL & User & ",'LOGIN','" & fDate & "','" & CheckInTime & "','" & Location & "')"
			my_Conn.Execute (strSql)
		   if err.number <> 0 then response.write err.number & "|" & err.description
	 else
		strSql = "UPDATE FORUM_ONLINE SET M_BROWSE =  '" & Location & "' , DateCreated = '" & fDate & "' WHERE UserID = '" & User & "'"
		my_Conn.Execute (strSql)
	end if

everything works OK.

---