ASP-SQL 数据更新问题

[losgou]

Set objConnection = Server.CreateObject ("ADODB.Connection")
objConnection.Open "FAFA","sa",""
SQLQuery = "SELECT * FROM TONGJIBIAO"
Set rsRecordset = Server.CreateObject ("ADODB.Recordset")
rsRecordset.Open SQLQuery,objConnection, adOpenKeyset
Do Until rsRecordset.EOF

//我在这里要对表所有数据更新
//错误的更新 rsRecordset("字段2")= rsRecordset ("字段2")+1
//是否与打开参数有关，望大侠指点
rsRecordset.MoveNext
LOOP

字段1 字段2
1 3
2 5
3 9
4 8

更新为
字段1 字段2
1 4
2 6
3 10
4 9

[losgou]

问题被我解决了，第一个给分我要结贴 ：））

[patchclass]

update

[zhlym]

那我来接分吧

[patchclass]

哈哈，我第一个，呵呵