asp 批量update 问题!
----错误提示--------------
Microsoft OLE DB Provider for ODBC Drivers 错误 '80004005'
基于查询的更新失败,因为没发现要更新的行。
/admin/inboundSQL.asp,行 406
-----代码------------------------
If Not PLFHRS.EOF Then
While Not PLFHRS.EOF
PLFHRS("FHSL") = Trim(PLFHRS("SL"))&"="&Trim(PLFHRS("YSCMFB"))
PLFHRS("FHSJ") = Now()
PLFHRS("FHR") = request.Cookies("loginname")
PLFHRS.update
PLFHRS.movenext
Wend
End If
while 4 次后就会出错!
哪位能帮帮忙,感谢
没人能回答此问题?
上下文贴一下看看,这些代码似乎没错
Set PLFHRS = server.CreateObject("ADODB.recordset")
PLFHRS.open "select FHSL,FHR,FHSJ,SL,YSCMFB from BM_ProcurementSystem where (FHSL='' or FHSL is null) and (FHSJ='' or FHSJ is null) and (YSCMFB <>'' or YSCMFB is not null) and FLAG <>1 and (RQ between '"&starttime&"' and '"&endtime&"')",conn,1,3
If Not PLFHRS.EOF Then
While Not PLFHRS.EOF
PLFHRS("FHSL")
相关问答:
<form id="form1" runat="server">
<div>
<script type="text/javascript">
function oo(a){
document.getEleme ......
news表里有pname(上层科目),mname(科目),type(分类)这三个字段;
下面这个递归.实验测试只能递归到110层..需要怎么改,才能无限??
JScript code:
function gethz(pname8,type8)
dim str,rs
......
<%On Error Resume Next
Set conn=Server.CreateObject("ADODB.Connection")
conn.begintrans
conn.Open ("Driver={SQL Server};server=(local);uid=sa;database=student;pwd=")
......
"title"这个值保存不了?请问高手错误原因
<%set rs=server.createobject("adodb.recordset")
rs.open "select * from question",conn,1,3
if ......