Else's blog

var tableObj = document.getElementById("tableName");
var str = "";
for(var i=0;i<tableObj.rows.length;i++)
{
   for(varj=0;j<tableObj.rows[i].cells.length;j++)
   {
      //str += tableObj.rows[i].cells[j].innerHTML+"   ";

           for(var z=0;z<tableObj.rows[i].cells[j].children.length;z++)
           {
        var text = tableObj.rows[i].cells[j].children[z];//取得text object
                str += text.value;
           }
   }
   str+="\n";
}
alert(str);

edit_rs_cmd.CommandText = "SELECT * FROM dbo.usertable WHERE id = ?"

edit_rs_cmd.CommandText = "SELECT *,[不能显示的字段],[不能显示的字段], FROM dbo.usertable WHERE id = ?"

edit_rs.Fields.Item("opentime").Value

edit_rs.Fields.Item(11).Value'time所在的顺序

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

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