ASP删除不了记录···急急
请高手帮忙看下下面代码有什么错,老是删除不了···
第一页adminok.asp,<ahref="adminokDel.asp?id=<%=rs("news_id")%>">〔删除〕</a>
第二页adminokdel.asp转到详细页代码:
<!--#includefile="Connections/conn.asp"-->
<%
setrs=server.createobject("adodb.recordset")
sql="select*fromnewsDatewherenews_id="&request.querystring("&id&")
rs1.opensql,conn,3,3
%>
%>
<html>
<head>
<metahttp-equiv="Content-Type"content="text/html;charset=gb2312">
<title>删除页面</title>
<styletype="text/css">
<!--
.style1{font-size:24px}
.style2{font-size:12px}
-->
</style>
</head>
<body>
<formname="form1"method="POST"action="del.asp">
<divalign="center">
<pclass="style1">删除页面</p>
<pclass="style2"><ahref="/adminok.asp">[返回管理界面]</a>
</p>
<tablewidth="304"border="0"cellspacing="0">
<tr>
<tdwidth="106">时间:</td>
<tdwidth="182"align="left"><%=(rs.Fields.Item("news_time").Value)%></td>
</tr>
<tr>
<td>英语标题:</td>
<tdalign="left"><%=(rs.Fields.Item("news_title").Value)%></td>
</tr>
<tr>
<td>英文内容:</td>
<tdalign="left"><%=(rs.Fields.Item("news_content").value)%></td>
</tr>
<tr>
<td>中文标题:</td>
<tdalign="left"><%=(rs.Fields.Item("news_swtitle").value)%></td>
</tr>
<tr>
<td>中文内容:</td>
<tdalign="left"><%=(rs.Fields.Item("news_sw").value)%></td>
</tr>
</table>
<p>
<inputtype="submit"name="Submit"value="确定删除">
<inputtype="hidden"name="id"value="<%=rs("news_id")%>">
</p>
</div>
</form>
</body>
</html>
第三页del.asp实行删除的代码:
<%
news_id=cstr(request.querystring("news_id"))
sqlstr="select*fromtb_newswherenews_id="&id
setrs=server.createobject("adodb.recordset")
rs.opensqlstr,conn,1,3
rs.delete
rs.update
rs.close
setrs=nothing
%>