<% set Command1 = Server.CreateObject("ADODB.Command") Command1.ActiveConnection = MM_conn_STRING Command1.CommandText = "UPDATE starwood SET my_count =my_count+1 WHERE id = 'zs'" Command1.CommandType = 1 Command1.CommandTimeout = 0 Command1.Prepared = true Command1.Execute() %> <% Dim Recordset1 Dim Recordset1_numRows Set Recordset1 = Server.CreateObject("ADODB.Recordset") Recordset1.ActiveConnection = MM_conn_STRING Recordset1.Source = "SELECT * FROM starwood" Recordset1.CursorType = 0 Recordset1.CursorLocation = 2 Recordset1.LockType = 1 Recordset1.Open() Recordset1_numRows = 0 %> <%=(Recordset1.Fields.Item("my_count").Value)%> <% Recordset1.Close() Set Recordset1 = Nothing %>