asp检测conn.execute是否执行成功的

asp

2008-09-27 16:23

dim a       '定义变量不赋值 直接输出是空值
sql="update [info] set wz='0' where id in (1,2,5)"
conn.execute sql,a
response.Write(a)
if a>0 then
response.write "更新成功"
else
response.write "更新失败"
end if

a 是影响的条数