ASP batch update code

<! -- # Include file = "../Conn. asp" -->
<%
Set rs = server. Createobject ("ADODB. recordset ")
SQL = "select * from article where bigtypes = 'I love you' order by id desc" find all the data in the database whose category is 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

RS ("filepath") = c_filepath
Rs. Update

Rs. movenext
Loop
End if
Response. Redirect "successful ....."
%>
Solution:CopyCodeThe Code is as follows: <%
Set rs = server. Createobject ("ADODB. recordset ")
SQL = "select * from article where bigtypes = 'I love you' order by id desc" find all the data in the database whose category is 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.exe cute ("update Article set filepath = '" & c_filepath & "'where id =" & RS ("ID "))

Rs. movenext
Loop
End if
Response. Redirect "successful ....."
%>