SQL数据库中多表删除问题

chenxingg 发布于 2009-12-18 18:09， 1565 次点击

程序
<%
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&"'")）

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

9 回复

aspic2009-12-18 18:16

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

chenxingg2009-12-18 19:30

前边有一个参数判断
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

chenxingg2009-12-18 20:43

我去跳楼了

delete

搞成了 delect