hi !! necesito actualizar el campo "statusDistrib" de la tabla "Plan" donde el codeDistrib = var9 (codeDistrib. tiene varios registros repetidos)
Código HTML:
<%
var2 = request.form("box_cc")
var3 = request.form("box_cf")
var9 = request.form("status")
Const adOpenKeyset = 1
Const adLockOptimistic = 2
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("newPlan.mdb"))
set rs=createobject("ADODB.Recordset")
rs.CursorType = adOpenKeyset
rs.LockType = adLockOptimistic
sql = "UPDATE Plan SET statusDistrib = '"& var9 &"' WHERE codeDistrib = '"&var2&"'"
rs.Open sql, Conn
Conn.Execute(sql)
rs.close
Conn.Close
set rs = Nothing
Set Conn = Nothing
%>