缘来缘去缘如水整首诗: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="&("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")&'