如果没有执行成功页面会显示服务器错误之类的错误信息,应该如何避免这种情况,出现命令执行成功or执行失

请问执行一条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

Published At
Categories with Web编程
comments powered by Disqus