荣耀路由2与pro对比:帮我看看这段ASP语句

来源:百度文库 编辑:高校问答 时间:2024/04/28 02:38:11
sql="select * from admin where admin_id="&id
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" &"Data Source=" & Server.MapPath(FileName)
objConn.Open
Set GetSQLRecordset = Server.CreateObject("ADODB.Recordset")
GetSQLRecordset.Open sql, objConn, adOpenKeyset, adLockOptimistic, adCmdText

GetSQLRecordSet("adminname")=name

GetSQLRecordSet.update
GetSQLRecordSet.close
set GetSQLRecordSet=nothing
objConn.close
set objConn=nothing

执行以上的语句后提示“BOF或EOF有一个为“真” 当前记录不存在或以被删除,执行需要一个当前的记录”
但是数据库里面的值已经被修改了,这是怎么回事啊?

我是修改记录,不是添加记录啊!!!

都不是这些原因啊,大家继续!

GetSQLRecordSet("adminname")=name

GetSQLRecordSet.update
GetSQLRecordSet.close
set GetSQLRecordSet=nothing
objConn.close
set objConn=nothing
改为:
GetSQLRecordSet.add
GetSQLRecordSet("adminname")=name

GetSQLRecordSet.update
GetSQLRecordSet.close
set GetSQLRecordSet=nothing
objConn.close
set objConn=nothing

GetSQLRecordset.Open sql, objConn, adOpenKeyset, adLockOptimistic, adCmdText
改为GetSQLRecordset.Open sql, objConn,1,3