I found some information on the Internet. Regarding the problem of cursors, I still can't put it in (if I find the method, I can change it). The previous SQL was written like this, but it has no effect. Some non-sequential values will be lost.
edit_rs_cmd.CommandText = SELECT * FROM dbo.usertable WHERE id = ?
At this time, you need to put the fields that cannot be displayed into sql and display them.
edit_rs_cmd.CommandText = SELECT *,[Fields that cannot be displayed],[Fields that cannot be displayed], FROM dbo.usertable WHERE id = ?
I found a way later
edit_rs.Fields.Item(opentime).Value
Bundle
The order in which edit_rs.Fields.Item(11).Value'time is located
But these are very complicated to do. After dw gives you the formula, you can use the following method
Set edit_rs_cmd = Server.CreateObject (ADODB.Command)
edit_rs_cmd.ActiveConnection = MM_conn_STRING
edit_rs_cmd.Prepared = true
edit_rs_cmd.CommandText = SELECT * FROM dbo.usertable WHERE id = ?
edit_rs_cmd.Parameters.Append edit_rs_cmd.CreateParameter(param1, 5, 1, -1, edit_rs__MMColParam) ' adDoubleset edit_rs = server.createobject(adodb.recordset)
edit_rs.open edit_rs_cmd ,,1,1
original method
Set edit_rs_cmd = Server.CreateObject (ADODB.Command)
edit_rs_cmd.ActiveConnection = MM_conn_STRING
edit_rs_cmd.Prepared = true
edit_rs_cmd.CommandText = SELECT *,[trytime],[opentime],[endtime],address,scale,content FROM dbo.usertable WHERE id = ?
edit_rs_cmd.Parameters.Append edit_rs_cmd.CreateParameter(param1, 5, 1, -1, edit_rs__MMColParam) ' adDouble
Set edit_rs = edit_rs_cmd.Execute
The following is nonsense. After adding it, none of it works, or the command attribute is added incorrectly!
Quote
CursorType parameter value
Parameter value description
AdOpenForwardOnly 0 forward pointer, default value. You can only use the MoveNext method or the GetRows method to move the pointer forward in one direction, which consumes the least system resources and has the fastest execution speed, but many properties and methods will not be available.
AdOpenKeySet 1 Keyboard pointer, the record set can move forward and backward. After a user modifies the data, other users can display it immediately, but it is prohibited to view the records added and deleted by other users.
AdOpenDynamic 2 dynamic pointer, which can move forward and backward in the record set. All modifications will be immediately displayed on other clients, which is powerful but consumes a lot of system resources.
AdOpenStatic 3 static pointer, which can be moved forward and backward in the record set. All modifications will not be displayed on other clients