hi this is code thats is used in modify more than one record in databse but no work is and generate error so any body help me to update more then one record in database.
<%conn.close
If Not IsEmpty(Request.Form("submit") then
vopenflg = Request.Form("vopenflg"
vopenflg=trim(vopenflg)
conn.Mode = adModeReadWrite
conn.open
R1.open "Select open_flg from topmaster ", conn, adOpenStatic, adLockOptimistic, adCmdText
do while not R1.eof
R1("open_flg"=vopenflg
R1.moveNext
R1.update
loop
R1.Close
conn.close
end if
%>

jha