使用事务出现了错误怎么还能插入?
test2表的userno字段是整形,我故意插入一个字符串,按理说应该回退,test1中插入的值也会被删除,但为什么每次都没有。
<%@TRANSACTION=Required%>
<!--#include file="conn.asp"-->
<%
on error resume next
cnn.BeginTrans
cnn.execute "insert into test1 values(1)"
cnn.execute "insert into test2(userno) values(""hello"")"
num=err.number
if num=0 then
cnn.committrans
cnn.close
else
cnn.rollbacktrans
response.Write(err.description)
cnn.close
response.End()
end if
%>