缘来缘去缘如水整首诗:SQL批量删除问题

来源:百度文库 编辑:高校问答 时间:2024/04/29 04:05:58
删除文件alldel.asp

<!--#include file="conn.asp"-->

<%
set reco=server.createobject("ADODB.recordset")
sqlstr="delete * from news where id="&("id")&"
reco.open sqlstr,conn
reco.close
set conn=nothing
Response.Redirect "1.asp"
Response.end
%>
..........................

报错如下:

Microsoft VBScript 编译器错误 错误 '800a03f6'

缺少 'End'

/iisHelp/common/500-100.asp,行242

Microsoft VBScript 编译器错误 错误 '800a0409'

未结束的字符串常量

admin/alldel.asp,行6

sqlstr="delete * from news where id="&("id")&"
----------------------------------------------^

<!--#include file="conn.asp"-->

<%
set reco=server.createobject("ADODB.recordset")
sqlstr="delete * from news where id="&request("id")
reco.open sqlstr,conn
reco.close
set conn=nothing
Response.Redirect "1.asp"
Response.end
%>

sqlstr="delete * from news where id='&("id")&' “或是sqlstr="delete * from news where id="&("id")

id='&("id")&'