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 ......
<!--#include file="Conn.asp"-->
<body>
<table border="0" align="left" cellpadding="0" cellspacing="0">
<%
URL ......
初学asp 知道可以定义多维数组
Dim a(5,3,2)
但是看到另外一种写法
Dim thisarray(1 to 10,-4 to 5, 5 to 11)
但是编译的时候出错
错误描述:缺少 ')'
如果解决??
VBScript和V ......
"title"这个值保存不了?请问高手错误原因
<%set rs=server.createobject("adodb.recordset")
rs.open "select * from question",conn,1,3
if ......