ASP Batch Update code _ Application Tips

<!--#include file= ". /conn.asp "-->
<%
Set Rs=server.createobject ("Adodb.recordset")
Sql= "SELECT * from article where bigtypes= ' I love you ' ORDER BY id DESC" Find the category in the database for all the data I love you
Rs.Open sql,conn,1,3
If not rs.eof then
Do as not rs.eof
fname = RS ("id") & ". html"
Folder = ".. /html/info/"
C_filepath = Folder&fname

RS ("filepath") =c_filepath
Rs.update

Rs.movenext
Loop
End If
Response.Redirect "Success ..."
%>
Workaround:

Copy Code code as follows:

<%
Set rs=server.createobject ("Adodb.recordset")
Sql= " Select * from article where bigtypes= ' I love you ' Order by id desc      find the category within the database for all the data I love you
rs.open sql,conn,1,3
If not rs.eof then
do  While not rs.eof
Fname = rs ("id") & ". html"
folder = . /html/info/"
C_filepath = folder&fname

Conn.execute (" Update article set  filepath= ' &c_filepath& '  where id= ' &rs ("id"))

Rs.movenext
Loop
END&N Bsp;if
response.redirect  "Success ..."
%>