Question

asp删除数据库信息

删除代码如下请帮我看看错在哪里
<!--#include file="Connections/web.asp" -->
<%

set Command1 = Server.CreateObject("ADODB.Command")
Command1.ActiveConnection = MM_web_STRING
Command1.CommandText = "UPDATE SET WHERE "
Command1.CommandType = 1
Command1.CommandTimeout = 0
Command1.Prepared = true
Command1.Execute()

%>
<%
set conn=server.createobject("adodb.connection")
conn.open = "provider=microsoft.jet.oledb.4.0;data source = "&server.mappath("data/data.mdb")

id=request.QueryString("id")
sql="delete from 用户表 where 用户ID="&id
conn.execute(sql)
response.Redirect("users.asp")
conn.close()
set conn=nothing
%>
每次都提示11行出错
还是不行啊！高手来指点一下啊！

Answer 1

你response.write sql把这个打印出来，看看SQL语句是否有问题，估计是id为空
另外conn.open = "provider=microsoft.jet.oledb.4.0;data source = "&server.mappath("data/data.mdb")

conn.open = 这个方式不对这个是一个函数，不是变量。

Answer 2

conn.open = "provider=microsoft.jet.oledb.4.0;data source = "&server.mappath("data/data.mdb")
改为：
conn.open "provider=microsoft.jet.oledb.4.0;data source = "&server.mappath("data/data.mdb")

Answer 3

sql="delete from 用户表 where 用户ID="&cstr(id)

试下.