i had problem when i Edit the Recorde and it show error

alpschints 0 Tallied Votes 315 Views Share

ADODB.Field error '80020009'

Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.

/nirmal/asp/editrecord.asp, line 0

<% @ language="vbscript" %>
<% option explicit %>
<%
dim con,selectqury,rs,i,ccode
 
'Get values from viewallcourses
ccode=request.querystring("ccode")
'create connection with database
set con=server.createobject("Adodb.connection")
con.connectionstring="PROVIDER=MSDAORA.1;USER ID=NIRMAL;PASSWORD=PATEL;DATA SOURCE=ORCL;PERSIST SECURITY=TRUE"
CON.OPEN()
'create recordset object
selectqury="select *from coursemaster where code='"&ccode&"'"
set rs=server.CreateObject("ADODB.Recordset")
rs.open selectqury,con
i=1
con.execute(selectqury)

%>