4,008
社区成员
发帖
与我相关
我的任务
分享
chk = request.form("chk")
cphm = request.form("cphm")
cphm = Replace(cphm,"'", "''")
conn.execute("update wfrec set zt=1,yx=" & chk & ",cphm='" & cphm & "' where id=" & id)
Set rs = CreateObject("ADODB.RecordSet")
rs.CursorLocation = 3
rs.Open "SELECT * FROM wfrec WHERE id=" & id, conn, 1, 3
If Not(rs.EOF And rs.BOF) Then
rs("zt").value = 1
rs("chk").value = request.form("chk")
rs("").value = request.form("cphm")
rs.Update
rs.Close
End If
Set rs = Nothing
conn.Close
Set conn = Nothing