请问执行一条sql的插入语句如
mycon.execute "insert table1 (c1,c2,c3) values (v1,v2,v3)"
我如何判断这条语句是否顺利执行呢?
应该如何作?
多谢!
---------------------------------------------------------------
1
2on error resume next
3...
4...
5mycon.execute "insert table1 (c1,c2,c3) values (v1,v2,v3)"
6
7if err.number<>0 then
8response.write "出现错误,详细信息:" & err.description
9end if
if err.number < >0 then
response.write "执行错误,出现错误,详细信息: " & err.description
else
response.write "执行成功 "
end if
'-----------你看一下asp书中的error对象,就知道了-------------
---------------------------------------------------------------
on error resume next
mycon.execute "insert table1 (c1,c2,c3) values (v1,v2,v3)"
if err then
response.write "有错误"
else
response.write "正确"
end if