如何判断conn.Execute成功 或失败？

代码：

<%

dim sql

sql="select * from table"

on error resume next

conn.execute(sql)

if err.number=0 then

Response.Write "成功！"

else

Response.Write "失败"

end if

%>