Self-developed blog: http://www.ylhd.com/aa7643/dds_blog/ Usually people use two methods to perform SQL statements: SET RS = conn.execute (SQLSTR) and SET RS = Server.createObject ("AdoDB .Recordset ") RS.Open SQLSTR, CONN, CURSORTYPE, LOCKTYPE
(Recordset object method, please see here)
Since the default recordset is a server cursor, rs.cursorLocation = aduseserver is returned to RS.RecordCount = -1, and the server cursor should be changed to the client game, RS.CursorLocation = Aduseclientrs.open Sqlstr, Conn, Cursortype, LockType
Rs.cursortype
Cursor Type Recordcount Properties ------------------------------------------- Forwardonly 0 (default) Returns -1 KeySet 1 The correct record number Dynamic 2 -1 or incorrect record number, according to the data source, Static 3 correct record number
So rs.cursorlocation = 3
This property is supported by the RecordSet.support ("Property Name").