error mesage...help

10 Oct 2006 8:12 AM

amatuer

Microsoft OLE DB Provider for SQL Server error '80040e24'

Rowset does not support fetching backward.

/reenval/reen_mnde1.asp, line 16

code:

    do while not(rstMainJr.eof)
    JaarAantal = JaarAantal +1
    rstMainJr.movenext
    Loop

    'JaarAantal = rstMainJr.recordcount

16-    rstMainJr.movelast
17-    Laastejaar = rstMainJr("jaar")

Any sugestions?....thanx

10 Oct 2006 8:30 AM

Mike Brind

Show quote Hide quote

"amatuer" <njoo***@gmail.com> wrote in message
news:1160467923.459389.190470@c28g2000cwb.googlegroups.com...
> Microsoft OLE DB Provider for SQL Server error '80040e24'
>
> Rowset does not support fetching backward.
>
> /reenval/reen_mnde1.asp, line 16
>
> code:
>
>
>    do while not(rstMainJr.eof)
>    JaarAantal = JaarAantal +1
>    rstMainJr.movenext
>    Loop
>
>    'JaarAantal = rstMainJr.recordcount
>
> 16- rstMainJr.movelast
> 17-    Laastejaar = rstMainJr("jaar")
>
>

http://tutorials.aspfaq.com/8000xxxxx-errors/why-do-i-get-80040e24-errors.html

--
Mike Brind

11 Oct 2006 6:49 AM

amatuer

Thanx Mike, that site helped alot.

Mike Brind wrote:
Show quoteHide quote

> "amatuer" <njoo***@gmail.com> wrote in message
> news:1160467923.459389.190470@c28g2000cwb.googlegroups.com...
> > Microsoft OLE DB Provider for SQL Server error '80040e24'
> >
> > Rowset does not support fetching backward.
> >
> > /reenval/reen_mnde1.asp, line 16
> >
> > code:
> >
> >
> >    do while not(rstMainJr.eof)
> >    JaarAantal = JaarAantal +1
> >    rstMainJr.movenext
> >    Loop
> >
> >    'JaarAantal = rstMainJr.recordcount
> >
> > 16- rstMainJr.movelast
> > 17-    Laastejaar = rstMainJr("jaar")
> >
> >
>
> http://tutorials.aspfaq.com/8000xxxxx-errors/why-do-i-get-80040e24-errors.html
>
> --
> Mike Brind