0

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)

%>
1
Contributor
0
Replies
1
Views
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.