I am getting the following error message when trying to update recordset in "While" looping:

Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype(Although the record get updated when I update single record).

My code:

    set rsMoveNodeDown= Server.CreateObject ("ADODB.Recordset")

    sSQL = "SELECT * from Contents WHERE Parent = " & iParent & " AND Ordr in(" & iNode & "," & iNodeAfter & ") ORDER BY Ordr "
    'Response.Write sSQL
    'Response.End

    rsMoveNodeDown.Open sSQL, objConn,2,2 ' adOpenKeyset CursorType

While not rsMoveNodeDown.EOF
if rsMoveNodeDown.EOF then
    rsMoveNodeDown.Close
    Set rsMoveNodeDown = Nothing
end if
    rsMoveNodeDown("Parent") = iParent
    rsMoveNodeDown("Ordr") = iNode+1
    rsMoveNodeDown.Update

rsMoveNodeDown.MoveNext
    iNode = iNode-1
wend

Pay attention to your LockType

Try changing:
sMoveNodeDown.Open sSQL, objConn,2,2 ' adOpenKeyset CursorType
To:
sMoveNodeDown.Open sSQL, objConn, adOpenKeyset, adLockPessimistic ' adOpenKeyset CursorType


- A.Kahtava