114
Dear Friends,
I have create a form in which user can update his/her records. The data can retrieved from the code which i have put in dropdown menu. Now I want to display all the records as per the dropdown menu changed.
I have retrieved proposalcode from the table in a dropdown menu and from that dropdown menu I am selecting records from the same table.
I have tried it but I don't know why I am getting error.
I am getting the following error:
ADODB.Field error '800a0bcd'
Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
/prog_report_qtrly.asp, line 20
Here is the code.................
[HTML]<!-- #include file="include/connection.asp" -->
<%
propcode_list = request.form("propcode_list")
DIM mySQL_code,mySQL_code1
mySQL_code = "SELECT propcode FROM register_confirmed"
mySQL_code1 = "SELECT * FROM register_confirmed where propcode = '"& propcode_list &"'"
DIM objRS, objRS2
Set objRS = Server.CreateObject("ADODB.Recordset")
Set objRS2 = Server.CreateObject("ADODB.Recordset")
objRS.Open mySQL_code1, con
objRS2.Open mySQL_code, con
if objRS2.recordcount = 0 then
response.write "No records found"
else
propcode2 = objRS("propcode")
proptitle2=objRS("proptitle")
end if
%>
<html>
<head>
<script language="JavaScript">
function gone()
{
location=document.frm.propcode.options[document.frm.propcode.selectedIndex].value
}
</script>
</head>
<form name="frm" action="codeview.asp" method="post">
<select name="propcode_list">
<%
if objRS2.recordcount = 0 then
%>
<option value="empty">No records found</option>
<%
else
On Error Resume Next
objRS2.MoveFirst
do while Not objRS2.eof
propcode1= objRS2("propcode") %>
<option <% if propcode_list= propcode1 then %> selected<% end if %> value="<%= propcode1 %>"><%= propcode1 %></option>
<%
objRS2.MoveNext
loop
end if
%>
</select>
<input type="submit" value="Submit">
</form>
<%
response.write (propcode2)
response.write "<BR>"
response.write (proptitle2)
%>[/HTML]
Please help me out..........I really need it on urgent basis.....
Thanks
Deepak
