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

alpschints 0 315 Views

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)

%>
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.

Edit Preview