UC知道asp数据库数据怎么删除不掉
来源：百度知道 编辑：UC知道 时间：2024/06/18 23:12:39
这是我数据删除处理程序：
<%
dim sql
dim rs
dim aa
aa=request("id")
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" &_
"Data Source=" & Server.MapPath("classmate.mdb")
Conn.Open
set rs=server.createobject("adodb.recordset")
sql = "delete FROM classmate WHERE 姓名=" & "'" & aa & "'"
rs.Open sql,conn,1,2
set rs=nothing
aa=aa & "同学信息已经删除！"
%>
<script language="vbscript">
alert("<%=aa%>")
window.location.href = "index.asp"
</script>
<%
dim sql
dim rs
dim aa
aa=request("id")
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" &_
"Data Source=" & Server.MapPath("classmate.mdb")
Conn.Open
set rs=server.createobject("adodb.recordset")
sql = "delete FROM classmate WHERE 姓名=" & "'" & aa & "'"
rs.Open sql,conn,1,2
set rs=nothing
aa=aa & "同学信息已经删除！"
%>
<script language="vbscript">
alert("<%=aa%>")
window.location.href = "index.asp"
</script>
将下面的这句
sql = "delete FROM classmate WHERE 姓名=" & "'" & aa & "'"
改成
sql = "delete FROM classmate WHERE 姓名=" & aa
就可以啦
你的request("id") 是ID还是姓名？
要是ID的话就不能姓名='" & aa & "'"
要是的话改下这个试试
sql = "delete FROM classmate WHERE 姓名='" & aa & "'"