asp方面的,为什么不能更新数据

来源:百度知道 编辑:UC知道 时间:2024/06/15 12:51:08
代码如下:
<%@ LANGUAGE="VBSCRIPT" %>
<%
if request.cookies("adminok")="" then
response.redirect "login.htm"
end if
%>
<!--#include file="conn.asp"-->
<%
dim SQL, Rs,contentID
CurrentPage = request("Page")
contentID=request("ID")

set rs=server.createobject("adodb.recordset")
sqltext="delete from borecorder where bo_id="& contentID
rs.open sqltext,conn,3,3
set rs=nothing

dim Rt,CurrentPage
CurrentPage = request("Page")

////////////这个下面的不能更新
set rt=server.createobject("adodb.recordset")
sqltext="select from bo_device where device_name='"& request("Dname")&"'"
rt.open sqltext,conn,3,3
rt("Leave")=rt("Leave")+request("Rnum")

set rt=server.createobject("adodb.recordset")
sqltext="select * from bo_device where device_name='"& request("Dname")&"'"
rt.open sqltext,conn,3,3
rt("Leave")=rt("Leave")+request("Rnum")
response.redirect "info_check.asp?page="&CurrentPage
%>