1. 论坛系统升级为Xenforo,欢迎大家测试!
    Dismiss Notice

关于删除数据的问题

Discussion in '后端开发' started by leehui1983, Mar 2, 2006.

  1. leehui1983

    leehui1983 New Member

    Joined:
    Feb 26, 2006
    Messages:
    130
    Likes Received:
    0
    我写的删除代码为何只能删除数据,却不能删除数据那一行?
    <!--#include file="conn.asp"-->
    <%
    delid=request.Form("id")
    call delfeedback()
    sub delfeedback() '留言删除
    if delid="" or isnull("delid") then '要删除的记录id 为空
    '则给出提示
    response.write "<script>alert('操作失败,没有选择合适参数,请单击“确定”返回!');</script>"
    response.redirect "admin_edit.asp" '返回到留言管理界面
    response.end

    else 'id 存在
    '执行数据库中的删除操作,删除数据库中id 列的值在delid数组中的记录
    conn.Execute("delete * from news_comment where ID in ("&delid&")")
    '删除成功,给出提示
    response.write "<script>alert('留言删除成功,请单击“确定”返回!');</script>"
    response.redirect "admin_edit.asp" '返回到留言管理界面
    response.end
    end if
    end sub
    %>
     
  2. Ulysses

    Ulysses New Member

    Joined:
    Feb 5, 2006
    Messages:
    10,018
    Likes Received:
    16
    delid=request.Form("id")

    你确定这个 id 是通过表单提交?通常我们都是通过 URL 参数来提交的。

    如果你是在列表中,可以选择多项数据,那么删除的就不是一条数据而是至少一条数据,由你在列表中选择的数目决定。

    ID IN IDs 和 ID = ID ,结果不一样。
     
  3. woshidianpa

    woshidianpa New Member

    Joined:
    Nov 8, 2005
    Messages:
    89
    Likes Received:
    1
    sql = "delete * from news_comment where ID="&delid
    conn.Execute(sql)
     
  4. 小叶

    小叶 New Member

    Joined:
    Sep 4, 2005
    Messages:
    17,941
    Likes Received:
    33
    啊哦,,楼上的看看跟俺的不一样 哦。。:p
     
  5. 飞天宝

    飞天宝 New Member

    Joined:
    Mar 4, 2006
    Messages:
    12
    Likes Received:
    0
    sql = "delete from news_comment where ID="&delid
    conn.Execute(sql) ?
     
  6. comic

    comic New Member

    Joined:
    Mar 5, 2006
    Messages:
    302
    Likes Received:
    2
    简单明了哈哈