modify and update record in oracle database if multiple rows select through form and submit one record is updated with r.update but i wants to update more than one rows modify and update so plz help me
i am using code:(Asp)
        <td width="10%"><b>Apply</b>
         <select name="vopenflg">
        <%If IsEmpty(vopenflg) or vopenflg = 0 Then%>
          <option value="0" selected>No</option>
          <option value="1">Yes</option>
          <option value="2">clsoe</option>
         <%Elseif vopenflg =1 Then%>
          <option value="0">No</option>
          <option value="1" selected>Yes</option>
          <option value="2">Close</option>
         <%Elseif vopenflg =2 Then%>
          <option value="0">No</option>
          <option value="1">Yes</option>
          <option value="2" selected>Close</option>
          <%End If%>
      </select>
 <%
  If Not IsEmpty(Request.Form("submit")) then
  vopenflg = Request.Form("vopenflg")
  vopenflg=trim(vopenflg)
  conn.close
  conn.Mode = adModeReadWrite
  conn.open
  R1.open "Select open_flg from topmaster ", conn, adOpenStatic, adLockOptimistic, adCmdText
  R1("open_flg")= vopenflg
  R1.update
  R1.Close
  end if
%>

sanjeev

__________________
sanjeev