程序
<%
userid=request("del")
conn.execute("delete  from [userid] where userid='"&userid&"'")
conn.execute("delect from [usep] where userid='"&userid&"'")
conn.execute("delect from [bmp] where userid='"&userid&"'")
conn.execute("delect from [pipp] where userid='"&userid&"'")
conn.execute("delect from [ply] where userid='"&userid&"'")
conn.execute("delect from [pipp] where userid='"&userid&"'")
conn.execute("delect from [ptexts] where userid='"&userid&"'")
response.Redirect(request.ServerVariables("HTTP_REFERER"))
end if
%>

删除时只执行第一句（conn.execute("delete  from [userid] where userid='"&userid&"'")）

其他的不执行，不知道什么原因

好神奇~
没有if？直接end if？

前边有一个参数判断
if request("del")<>"" then
userid=request("del")
conn.execute("delete  from [userid] where userid='"&userid&"'")
conn.execute("delect from [usep] where userid='"&userid&"'")
conn.execute("delect from [bmp] where userid='"&userid&"'")
conn.execute("delect from [pipp] where userid='"&userid&"'")
conn.execute("delect from [ply] where userid='"&userid&"'")
conn.execute("delect from [pipp] where userid='"&userid&"'")
conn.execute("delect from [ptexts] where userid='"&userid&"'")
response.Redirect(request.ServerVariables("HTTP_REFERER"))
end if

我去跳楼了

delete

搞成了 delect

那你就跳楼吧，我们就不拉了

你们都很牛叉 delete 都语句写错了，你看看能不能表与表之间用User_id 连接然后再跟据User_id进行删除！我没试过，我只试过Select 语句多表查询

嘿嘿，这个错误想当初俺们都犯过N次耶！经常写错单词。。。。
不过，熟练之后就不会经常写错了。

这样的删除不能写触发器吗？

SQL用触发器好了,应可减软WEB工作量吧