紧急求助!ASP更新数据库,错误代码“-2147168242”

来源:百度知道 编辑:UC知道 时间:2024/06/22 02:01:31
<!-- #include file="db.inc.asp" -->

<% on error resume next %>
<%
'创建RECORDSET对象方法1
set rst=Server.CreateObject("ADODB.recordset")
rst.open "select * from dateup where d_ip='" & Request.QueryString("ip") & "'",conn,1,1
if rst.recordcount>0 then
rst.close
'错误在这句:========================
rst.open "update dateup set d_date='" & Request.QueryString("datenow") & "' where d_ip='" & Request.QueryString("ip") & "'",conn,1,1
'=================================
rst.close
if err.number<>0 then
conn.rollbacktrans
%>
Err:
<%
response.Write(err.number)
else
conn.committrans
%>
OK
<%
end if
set rst=nothing
conn.close
s

rst.open "update dateup set d_date='" & Request.QueryString("datenow") & "' where d_ip='" & Request.QueryString("ip") & "'",conn,1,1
rst.close
改成
conn.execute("update dateup set d_date='" & Request.QueryString("datenow") & "' where d_ip='" & Request.QueryString("ip") & "'")
请注意,rst.open不能直接运行更新或添加语句,它只能执行select语句