strconn ="Provider=Microsoft.Jet.OLEDB.4.0; Data Source="& server.mappath("db/forum.mdb") conn.open strconn set rs=server.createobject("adodb.recordset")
rs.Open "select * from [mymember]",conn,3,2
----------------------------------------------
维护世界和平,共创美好盒子。
一下语法为ASP+SQL Server2K <% rs.Open "select * from [mymember] oder by score",conn,3,2 排序 if not rs.eof then while not rs.eof do reaponse.write rs("team")&"<a href=edit.asp?id="&rs("id")&">edit</a> " rs.movenext wend else response.write "五纪录" end if rs.close %>
然后。edit.asp中 …… typeid=request("id") sql="select * from 表名 where id='"&typeid&"'" rs.open sql,cn,1,1 temp=rs("team") rs("team")=temp+3 rs.update rs.close set rs=nothing …… ……