我有以下简短的经典ASP代码,可以进行SQL insert调用……
cmd.CommandText = "insert into MyTable values(blah, blah, blah)"
cmd.CommandType = adCmdText
Set rs = cmd.Execute()使用Execute()返回的记录集,我如何判断插入是否成功?
发布于 2010-03-04 02:05:46
检查Err对象
cmd.CommandText = "insert into MyTable values(blah, blah, blah)"
cmd.CommandType = adCmdText
On Error Resume Next
Set rs = cmd.Execute()
If Err.number<>0 or objConnection.Errors.Count <> 0 Then
'Do something to handle the error
End If
On Error Goto 0也可以在15Seconds上查看此链接
发布于 2010-03-04 07:59:54
如果不想检查错误,可以执行以下操作:
cmd.CommandText = "insert into MyTable values(blah, blah, blah) SELECT @@Rowcount"
cmd.CommandType = adCmdText
Set rs = cmd.Execute()
RecordsAffected = rs(0)同样,如果您有一个identity列,则可以使用以下命令获得结果id
cmd.CommandText = "insert into MyTable values(blah, blah, blah) SELECT @@Identity"
cmd.CommandType = adCmdText
Set rs = cmd.Execute()
NewID = rs(0)https://stackoverflow.com/questions/2373448
复制相似问题