Question

asp 数据库删除数据

显示语法错误
id=Trim(Request.Form("id"))

sql = "delete from 安装 where 业务编号 like '"&id&"' and 当前状态 = '"&安装施工&"'"

rs.open sql,conn,1,3
response.write "<script>alert('删除成功');location.href='wazx.asp';</script>"

sqlconn.close
set sqlconn = nothing
改成这样还是不能删除
sql ="delete from [安装] where [业务编号] = "&id&" and [当前状态]='安装施工'"

Answer 1

改为sql ="delete from [安装] where [业务编号] like "&id&" and [当前状态]='安装施工'" 试下看或把[ ]内的中文改为英文

追问

没有报错，就是这条数据没有删除

追答

[业务编号] like "&id&" 改为 [业务编号]="&id&"

Answer 2

sql ="delete from [安装] where [业务编号] like '*"&id&"*' and [当前状态]='安装施工'"

或者
sql ="delete from [安装] where instr([业务编号],'"&id&"')>0 and [当前状态]='安装施工'"

Answer 3

delete from xinghao where id not in ( select max(id) from xinghao group by xinghao ) -- 找到重复的xinghao内容的记录，并且删除之前出现的相同内容的记录，留下最后一次相同记录的内容