关于删除数据

[Angela001]

用到调用
location.href('Delete.asp?M=<%= Request("M")%>');

Delete.asp文件

str = Request.form("Email")

sql_ = "delete From tabUser where Email = '"& request.Form("Email") &"'"

Conn.Execute sql_

CloseConn conn

set upload=nothing

那里有错误阿？

[一天到晚游泳的鱼2016]

location.href('Delete.asp?M=<%= Request("M")%>');

Delete.asp文件

str = Request.form("M")---》这里应这样接受啊

sql_ = "delete From tabUser where Email = '"& str &"'"

Conn.Execute (sql)

CloseConn conn

[gggmmtddir]

你用的是查询字符串，接收的时候应该用
str=request.querystring("m")
然后，其后的语句，请参考楼上几位的回答

[一天到晚游泳的鱼2016]

晕，我也写错了因该是str = Request("M") 或者str=request.querystring("m")
都可以
然后在下面加上 response.write sql
打印出sql在查询分析中执行看可以删除不
如果能删除就不是sql的错误
你就检查程序

[littlelam]

location.href('Delete.asp?Email=<%= Request("M")%>');

Delete.asp文件

str = Request("Email")

sql_ = "delete From tabUser where Email = '"& request("Email") &"'"

Conn.Execute sql_

CloseConn conn

set upload=nothing

[peijunfeng]

看你的代码，应该是点击链接到Delete.asp的吧，而且删除的条件是“M”传过去的。如果是这个意思的话，你的代码修改如下：

location.href('Delete.asp?M=<%= Request("M")%>');

Delete.asp文件

Mail = Request("M")

sql_ = "delete From tabUser where Email = '"& Mail &"'"

Conn.Execute sql_

CloseConn conn

set upload=nothing

[Angela001]

还是不行啊。晕！