944,135 Members | Top Members by Rank

Ad:
  • ASP Discussion Thread
  • Unsolved
  • Views: 4409
  • ASP RSS
Mar 12th, 2006
0

problem with ADODB.Field error '80020009'

Expand Post »
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 !!!!
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
phillips is offline Offline
1 posts
since Mar 2006

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in ASP Forum Timeline: hyperlink
Next Thread in ASP Forum Timeline: Merge two string





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC