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

By alpschints on Mar 21st, 2009 10:39 am

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)

%>

This article has been dead for over three months

You