[求助]如何使用Update语句
程序如下:数据表中有yy,sx,yy,zf字段
<%Set Conn = Server.CreateObject("ADODB.Connection")
Strcon="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("xscj.mdb")
Conn.open Strcon
Set Rs1 = Server.CreateObject("ADODB.Recordset")
sql = "SELECT yw+sx+yy as su ,zf FROM cj008211 "
Rs1.open sql,conn,1,1
While (NOT Rs1.EOF)
在这里如何加Update语句才能记录zf把修改成su
Rs1.MoveNext()
Wend%>