注册 登录
编程论坛 ASP技术论坛

asp怎么判断数据是否被删除我是这样写的

夜龙魂 发布于 2009-11-16 11:22, 1155 次点击
bcid=request("bcid")
    set rs=Server.CreateObject("adodb.recordset")
    sql="delete from beautycontent where bcid="&bcid&""
    set rs=conn.Execute(sql)
5 回复
#2
wanglingxing12009-11-16 12:19
bcid=request("bcid")
    set rs=Server.CreateObject("adodb.recordset")
    sql="delete from beautycontent where bcid="&bcid&""
dim bdicount
    set rs=conn.Execute(sql,bdicount)
if bdicount>0 then response.write("成功")


#3
aspic2009-11-16 14:54
set rs=Server.CreateObject("adodb.recordset")
后面用的conn.execute那么上面这句就是多余的
#4
yms1232009-11-16 16:08
如果是判断是否成功执行删除可以利用错误捕捉的方法
On Error Resume Next
sql="delete from beautycontent where bcid="&bcid&""
conn.Execute(sql)
IF Err.Nmbuer=0 Then
   Response.Write "删除成功"
Else
   Response.Write "删除失败"
   Response.Write "原因:"&Err.Description
End IF
如果是判断删除后数据是否还存在就要进行读取
bcid=request("bcid")
sql1="delete from beautycontent where bcid="&bcid&""
sql2="select * from beautycontent where bcid="&bcid
conn.Execute(sql1)
Set rs=conn.execute(sql2)
if rs.eof then
   Response.write "数据已经被删除"
End IF
#5
gupiao1752009-11-18 22:07
yms123依旧还是那么牛比啊!
#6
wcwtitxu2010-01-25 13:47
以下是引用wanglingxing1在2009-11-16 12:19:28的发言:

bcid=request("bcid")
    set rs=Server.CreateObject("adodb.recordset")
    sql="delete from beautycontent where bcid="&bcid&""
dim bdicount
    set rs=conn.Execute(sql,bdicount)
if bdicount>0 then re ...

UP
1