asp在 操作 sql server 的update时 返回 更新条目数可以在 connection的execute方法中放入一个参量,调用方法如 conn.execute(sql,i),这个i就记录了
更新的条目数,示例代码:
connSQLServerStr
=
"
Provider=SQLOLEDB.1;server=192.168.1.28;uid=test;pwd=test;database=testDBSqlServer
"
set conn = server.CreateObject( " adodb.connection " )
conn.open connSQLServerStr
id = request( " id " )
sql = " update test set name= 'hello' where id= ' " & id & " ' "
conn.execute sql, i
response.Write( " 更新数目为: " & i)
connection对象execute方法的参考资料链接为:
http://www.w3school.com.cn/ado/met_conn_execute.asp
set conn = server.CreateObject( " adodb.connection " )
conn.open connSQLServerStr
id = request( " id " )
sql = " update test set name= 'hello' where id= ' " & id & " ' "
conn.execute sql, i
response.Write( " 更新数目为: " & i)