| | |
problem with ADODB.Field error '80020009'
Please support our ASP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
![]() |
•
•
Join Date: Mar 2006
Posts: 1
Reputation:
Solved Threads: 0
i had problem when i updated my record. and it show error
ADODB.Field error '80020009'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/bgempiece/Admin/updatestudents.asp, line 0
code:
Dim objConn, flag
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString= Constr
objConn.open
Dim objRs
set objRs = server.CreateObject("ADODB.Recordset")
objRs.open "infousers", objConn, adOpenDynamic, adLockOptimistic, adCmdTableDirect
if request.Form("Subupstd")= "Submit" then
do while not objRs.eof
if( objRs.Fields("Account")= request.Form("oldaccount")) then
with objRs
.Fields("Account")= request.Form("Account")
.Fields("Password")=request.Form("Password")
.Fields("Username")=request.Form("Name")
.Fields("Address") = request.Form("address")
.Fields("Country") = request.Form("Country")
if request.Form("phone") <> "" then
.Fields("HomePhone") = request.Form("phone")
end if
.Fields("Birthday") = request.Form("birthday")
if(request.Form("notes") <> "") then
.Fields("Notes") = request.Form("notes")
end if
.update
end with
exit do
end if
objRs.MoveNext
loop
response.Write("Update successfully!")
end if
help me plzzz !!!!
ADODB.Field error '80020009'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/bgempiece/Admin/updatestudents.asp, line 0
code:
Dim objConn, flag
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString= Constr
objConn.open
Dim objRs
set objRs = server.CreateObject("ADODB.Recordset")
objRs.open "infousers", objConn, adOpenDynamic, adLockOptimistic, adCmdTableDirect
if request.Form("Subupstd")= "Submit" then
do while not objRs.eof
if( objRs.Fields("Account")= request.Form("oldaccount")) then
with objRs
.Fields("Account")= request.Form("Account")
.Fields("Password")=request.Form("Password")
.Fields("Username")=request.Form("Name")
.Fields("Address") = request.Form("address")
.Fields("Country") = request.Form("Country")
if request.Form("phone") <> "" then
.Fields("HomePhone") = request.Form("phone")
end if
.Fields("Birthday") = request.Form("birthday")
if(request.Form("notes") <> "") then
.Fields("Notes") = request.Form("notes")
end if
.update
end with
exit do
end if
objRs.MoveNext
loop
response.Write("Update successfully!")
end if
help me plzzz !!!!
![]() |
Similar Threads
- ADODB.Field error '80020009' (ASP)
- error '80020009' Exception occurred. (ASP)
- error '80020009' Exception Occured (ASP)
Other Threads in the ASP Forum
- Previous Thread: hyperlink
- Next Thread: Merge two string
| Thread Tools | Search this Thread |
archive asp asp.net aspandmssqlserver2005 aspandmssqlserver2005connection aspconnection connection database databaseconnection dreamweaver excel fso iis msmsql mssql2005 mssqlserver2005 mssqlserver2005andasp mssqlserverandasp opentextfile record searchbox selectoption single specfic sqlserver sqlserverconnection windows7





