Question

asp怎么判断sql语句是否执行成功

Answer 1

如果用<%@ Language=vbScript%>的话
用Err.Number来判断
Err.Number<>0
表示代码运行有错误
Dim Rs
Dim Conn
On Error Resume Next
set Rs= Server.CreateObject("ADODB.RecordSet")
set Conn=Server.CreateObject("ADODB.Connection")
Conn.open "File Name=" & Server.MapPath("\Server.UDL")
if Conn.State=1 then

Rs.open "Select * From Pda_gl_user where md='" & m(0) & "'",Conn,1,1
if Rs.State<>0 then Rs.Close
else
s="获取用户权限失败!数据库连接失败!"
end if
if Err.Number=0 then
执行成功
else
执行失败
end if