|
 |
asp_web_howto thread: Error: "Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record.
Message #1 by "Sukhi" <sukhdeepsamra@h...> on Wed, 22 Aug 2001 18:38:01
|
|
I have a drop down box on one page, from which i select a user name. And
it should display teh user info
on the same page. Please see the code below for details..
When i select a user name from drop down, this is the error i am getting:
ADODB.Field error '80020009'
"Either BOF or EOF is True, or the current record has been deleted.
Requested operation requires a current record. ? "
i am using the same code to do the saem thing on other pages..and it works
fine..but i don't know why on this pgae it doesn't work. Do you think it
might be hass to do with the way table is originally created?
any feedback will be helpful..thanks!!
<form method="post" name="frmUser" action="fdelete2.asp">
<select name=cboUser size=1 onChange="frmUser.submit();" tabindex="0">
<option value="None">---Please Select Username---
<%
do until rstemp.eof %>
<option value=" <%=rstemp("User_ID")%>"> <%=rstemp("User_fname")%
></option>
<%
rstemp.movenext
loop
%>
</select>
</form>
</center>
<form method="post" name="frmUserDetails" action="fdeletedetails.asp">
<%
If Request.Form("cboUser")<>"" Then
mySQL2="select * from tblUser where User_ID= '"&Request.form("cboUser")&"'"
set rs2=conntemp.execute(mySQL2)
%>
<p align="center">
You have selected to delete the following User: </p>
<% response.Write rs2("User_ID")%>
<% response.Write rs2("User_fname")%>
</form>
Message #2 by "Joe Ehrenfeld" <joee@v...> on Wed, 22 Aug 2001 22:10:53
|
|
I'm not sure if this will do the trick but in looking at your html code it
looks like you forgot to close one of the option value tags:
<option value="None">---Please Select Username---
<%
should be:
<option value="None">---Please Select Username---</option>
<%
Hope that works for you.
> I have a drop down box on one page, from which i select a user name.
And
> it should display teh user info
> on the same page. Please see the code below for details..
>
> When i select a user name from drop down, this is the error i am getting:
> ADODB.Field error '80020009'
>
> "Either BOF or EOF is True, or the current record has been deleted.
> Requested operation requires a current record. ? "
>
> i am using the same code to do the saem thing on other pages..and it
works
> fine..but i don't know why on this pgae it doesn't work. Do you think it
> might be hass to do with the way table is originally created?
>
> any feedback will be helpful..thanks!!
>
>
> <form method="post" name="frmUser" action="fdelete2.asp">
>
> <select name=cboUser size=1 onChange="frmUser.submit();" tabindex="0">
> <option value="None">---Please Select Username---
> <%
> do until rstemp.eof %>
> <option value=" <%=rstemp("User_ID")%>"> <%=rstemp("User_fname")%
> ></option>
> <%
> rstemp.movenext
> loop
> %>
> </select>
>
> </form>
> </center>
> <form method="post" name="frmUserDetails" action="fdeletedetails.asp">
>
> <%
> If Request.Form("cboUser")<>"" Then
>
> mySQL2="select * from tblUser where User_ID= '"&Request.form("cboUser")
&"'"
> set rs2=conntemp.execute(mySQL2)
>
> %>
>
> <p align="center">
>
> You have selected to delete the following User: </p>
>
> <% response.Write rs2("User_ID")%>
> <% response.Write rs2("User_fname")%>
>
> </form>
Message #3 by "Sukhi Samra" <sukhdeepsamra@h...> on Wed, 22 Aug 2001 14:49:36 -0700
|
|
I tried that, but still it 's giving me same error,
even though i do have the data there in the table, but
it's just not finding it :(
>From: "Joe Ehrenfeld" <joee@v...>
>Reply-To: "ASP Web HowTo" <asp_web_howto@p...>
>To: "ASP Web HowTo" <asp_web_howto@p...>
>Subject: [asp_web_howto] Re: Error: "Either BOF or EOF is True, or the
>current record has been deleted. Requested operation requires a current
>record.
>Date: Wed, 22 Aug 2001 22:10:53
>
>I'm not sure if this will do the trick but in looking at your html code it
>looks like you forgot to close one of the option value tags:
><option value="None">---Please Select Username---
><%
>should be:
><option value="None">---Please Select Username---</option>
><%
>
>Hope that works for you.
>
> > I have a drop down box on one page, from which i select a user name.
>And
> > it should display teh user info
> > on the same page. Please see the code below for details..
> >
> > When i select a user name from drop down, this is the error i am
>getting:
> > ADODB.Field error '80020009'
> >
> > "Either BOF or EOF is True, or the current record has been deleted.
> > Requested operation requires a current record. ? "
> >
> > i am using the same code to do the saem thing on other pages..and it
>works
> > fine..but i don't know why on this pgae it doesn't work. Do you think it
> > might be hass to do with the way table is originally created?
> >
> > any feedback will be helpful..thanks!!
> >
> >
> > <form method="post" name="frmUser" action="fdelete2.asp">
> >
> > <select name=cboUser size=1 onChange="frmUser.submit();" tabindex="0">
> > <option value="None">---Please Select Username---
> > <%
> > do until rstemp.eof %>
> > <option value=" <%=rstemp("User_ID")%>"> <%=rstemp("User_fname")%
> > ></option>
> > <%
> > rstemp.movenext
> > loop
> > %>
> > </select>
> >
> > </form>
> > </center>
> > <form method="post" name="frmUserDetails" action="fdeletedetails.asp">
> >
> > <%
> > If Request.Form("cboUser")<>"" Then
> >
> > mySQL2="select * from tblUser where User_ID= '"&Request.form("cboUser")
>&"'"
> > set rs2=conntemp.execute(mySQL2)
> >
> > %>
> >
> > <p align="center">
> >
> > You have selected to delete the following User: </p>
> >
> > <% response.Write rs2("User_ID")%>
> > <% response.Write rs2("User_fname")%>
> >
> > </form>
Message #4 by "Gerhard Wentink" <data@w...> on Thu, 23 Aug 2001 06:22:17 +0200
|
|
I suspect that somehow the query is not getting the User_ID. Try debugging
by placing
Response.Write Request.Form("cboUser")
Response.End
just above your query. If the resultpage displays nothing you know that
something goes wrong when submitting the form.
By the way: you forgot to close the first <option>
Regards
Gerhard Wentink
----- Original Message -----
From: "Sukhi Samra" <sukhdeepsamra@h...>
To: "ASP Web HowTo" <asp_web_howto@p...>
Sent: Wednesday, August 22, 2001 11:49 PM
Subject: [asp_web_howto] Re: Error: "Either BOF or EOF is True, or the
current record has been deleted. Requested operation requires a current
record.
>
> I tried that, but still it 's giving me same error,
> even though i do have the data there in the table, but
> it's just not finding it :(
>
> >From: "Joe Ehrenfeld" <joee@v...>
> >Reply-To: "ASP Web HowTo" <asp_web_howto@p...>
> >To: "ASP Web HowTo" <asp_web_howto@p...>
> >Subject: [asp_web_howto] Re: Error: "Either BOF or EOF is True, or the
> >current record has been deleted. Requested operation requires a current
> >record.
> >Date: Wed, 22 Aug 2001 22:10:53
> >
> >I'm not sure if this will do the trick but in looking at your html code
it
> >looks like you forgot to close one of the option value tags:
> ><option value="None">---Please Select Username---
> ><%
> >should be:
> ><option value="None">---Please Select Username---</option>
> ><%
> >
> >Hope that works for you.
> >
> > > I have a drop down box on one page, from which i select a user name.
> >And
> > > it should display teh user info
> > > on the same page. Please see the code below for details..
> > >
> > > When i select a user name from drop down, this is the error i am
> >getting:
> > > ADODB.Field error '80020009'
> > >
> > > "Either BOF or EOF is True, or the current record has been deleted.
> > > Requested operation requires a current record. ? "
> > >
> > > i am using the same code to do the saem thing on other pages..and it
> >works
> > > fine..but i don't know why on this pgae it doesn't work. Do you think
it
> > > might be hass to do with the way table is originally created?
> > >
> > > any feedback will be helpful..thanks!!
> > >
> > >
> > > <form method="post" name="frmUser" action="fdelete2.asp">
> > >
> > > <select name=cboUser size=1 onChange="frmUser.submit();" tabindex="0">
> > > <option value="None">---Please Select Username---
> > > <%
> > > do until rstemp.eof %>
> > > <option value=" <%=rstemp("User_ID")%>"> <%=rstemp("User_fname")%
> > > ></option>
> > > <%
> > > rstemp.movenext
> > > loop
> > > %>
> > > </select>
> > >
> > > </form>
> > > </center>
> > > <form method="post" name="frmUserDetails" action="fdeletedetails.asp">
> > >
> > > <%
> > > If Request.Form("cboUser")<>"" Then
> > >
> > > mySQL2="select * from tblUser where User_ID
'"&Request.form("cboUser")
> >&"'"
> > > set rs2=conntemp.execute(mySQL2)
> > >
> > > %>
> > >
> > > <p align="center">
> > >
> > > You have selected to delete the following User: </p>
> > >
> > > <% response.Write rs2("User_ID")%>
> > > <% response.Write rs2("User_fname")%>
> > >
> > > </form>
>
>
|
|
|
View Cart
