如何使用ADO说，如果到一个SQL调用execute（）在传统的ASP

Question

失败，我有以下的缩短传统的ASP代码，使SQL插入电话...

cmd.CommandText = "insert into MyTable values(blah, blah, blah)" 
cmd.CommandType = adCmdText 

Set rs = cmd.Execute() 

使用执行记录（ ）返回如何判断插入是否成功？

Answer 1

检查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

Answer 2

如果你不想检查错误，您可以：

cmd.CommandText = "insert into MyTable values(blah, blah, blah) SELECT @@Rowcount" 
cmd.CommandType = adCmdText 

Set rs = cmd.Execute() 
RecordsAffected = rs(0) 

在同样的waw，如果你有一个标识栏，你可以使用

cmd.CommandText = "insert into MyTable values(blah, blah, blah) SELECT @@Identity" 
cmd.CommandType = adCmdText 

Set rs = cmd.Execute() 
NewID = rs(0)