problem with ADODB.Field error '80020009'

Reply

Join Date: Mar 2006
Posts: 1
Reputation: phillips is an unknown quantity at this point 
Solved Threads: 0
phillips phillips is offline Offline
Newbie Poster

problem with ADODB.Field error '80020009'

 
0
  #1
Mar 12th, 2006
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 !!!!
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:



Similar Threads
Other Threads in the ASP Forum
Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC