请各位高手进来看看,小弟实在搞不懂呀………………在线等!!
以下的代码当我一个个删除时可以,当我选中多个时就不行呀(采用复选框)!我头都大了,请各位高手帮个忙!
当我选多个的时候出错如下:
Microsoft VBScript 编译器错误 错误 '800a03f6'
缺少 'End'
/iisHelp/common/500-100.asp,行242
Microsoft OLE DB Provider for ODBC Drivers 错误 '80040e14'
[Microsoft][ODBC Microsoft Access Driver] 语法错误 (逗号) 在查询表达式 'photo_id=1, 2' 中。
/test/admin/delecgal.asp,行8
请各位高手帮忙实现多个同时删除该怎么解决!!在线等
<%set conn=server.CreateObject("Adodb.Connection")
conn.open"driver={microsoft access driver (*.mdb)};dbq="&server.mappath("../sixstardate.mdb")
set rs=server.createobject("adodb.recordset")
if session("user")<>"" then
'删除
if request.form("aa")="删除" then
sql="select * from cgal where photo_id=" & request.form("id")
rs.open sql,conn
Set fso = CreateObject("Scripting.FileSystemObject")
filename=Server.MapPath("../cgalimage/"&rs("photo"))
fso.DeleteFile(filename)
set fso=nothing
'rs.delete
rs.close
set rs=nothing
sql="delete * from cgal where photo_id=" & request.form("id")
set rs=server.createobject("adodb.recordset")
rs.open sql,conn
end if
'显示
sql="select * from cgal order by photo_id"
if rs.state<>0 then rs.close
rs.open sql,conn
%><html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>删除行业动态信息</title>
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_openBrWindow(theURL,winName,features) { //v2.0
window.open(theURL,winName,features);
}
//-->
</script>
<style type="text/css">
<!--
.style1 {font-size: 12px}
-->
</style>
</head>
<body>
<table width="629" height="256" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="629" height="256" valign="top"><form name="form1" method="post" action="delecgal.asp">
<table width="98%" border="0" cellspacing="0" cellpadding="0" align="center" height="179">
<tr valign="bottom">
<td height="45" colspan="3"> <div align="center"><span class="style1">删除六星产品相关资料
</span>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><div align="right" class="style1"><a href="../index.asp">首页</a>
| <a href="admin.asp"> 发布</a></div></td>
</tr>
</table>
</div></td>
</tr>
<tr valign="middle">
<td colspan="3" height="21"> <div align="center" class=ss></div></td>
</tr>
<%while not rs.eof %>
<tr>
<td width="9%" height="25" rowspan="3"> <div align="center"><font color="#000000" size="2"><a href="modihydd.asp?id=<%=rs("photo_id")%>">修改</a></font></div></td>
<td width="6%" rowspan="3"><input type="checkbox" name="id" value="<%=rs("photo_id")%>"></td>
<td width="85%" height="30" class="ss" ><span class="style1">
<p>案例名称:<%=rs("titles")%><span class="style1"><br>
案例简述 :<%=rs("texts")%></span><br>
</p>
</span ></td>
</tr>
<tr>
<td height="2" bgcolor="#993333"></td>
</tr>
<tr>
<td height="12" class="ss" ><span class="style1">
<p> </p>
</span ></td>
</tr>
<%rs.movenext
wend
%>
<tr>
<td height="47" colspan="2" valign="bottom"> <div align="right"></div></td>
<td width="85%" height="47">
<input type="submit" name="aa" value="删除" class="ww"> <input type="reset" name="ss" value="重选" class="ww">
</td>
</tr>
<tr>
<td colspan="2"> <div align="right"></div></td>
<td width="85%"> <div align="right"></div></td>
</tr>
</table>
</form></td>
</tr>
</table>
</body>
</html>
<%end if%>