Classic ASP Discussion - rs.moveprevious error?

Print Page | Close Window

rs.moveprevious error?

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=3638
Printed Date: 29 March 2026 at 11:56pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: rs.moveprevious error?

Posted By: pmormr
Subject: rs.moveprevious error?
Date Posted: 18 June 2003 at 11:50am

I have the following code snippet. It gets the id number for the next and last records. It generates the error...

Microsoft JET Database Engine error '80040e24'

Rowset does not support fetching backward.

/_stuff/_comics/view_comic.asp, line 24

I opened it dynamically but it doesn't work. Any ideas?

   'Open the database connection
   Dim conn
   Set conn = Server.CreateObject("ADODB.Connection")
   conn.provider = "Microsoft.Jet.OLEDB.4.0"
   conn.mode = AdOpenReadOnly
   conn.open ("DATA SOURCE=c:\myfolder\myfolder2\mydatabase.mdb")

   'Open a recordset for the comics database
   Dim rs
   Set rs = Server.CreateObject("ADODB.Recordset")
   rs.Open "SELECT * FROM COMIC", conn, AdOpenDynamic

   If request.querystring("id") = "" then
      rs.movefirst
   else
      rs.move request.querystring("id")
   end if

   'Get the id number for the next record and the previous
   Dim nextrecord
   Dim lastrecord
   If rs.fields("cid") = 1 then
      rs.movelast
   lastrecord = rs.fields("cid")
   rs.movefirst
   rs.movenext
   nextrecord = rs.fields("cid")
   rs.moveprevious
   Else
      rs.movenext
   nextrecord = rs.fields("cid")
   rs.moveprevious
   rs.moveprevious
   lastrecord = rs.fields("cid")
   rs.movenext
   End If

-------------
Paul A Morgan

http://www.pmorganphoto.com/" rel="nofollow - http://www.pmorganphoto.com/

Replies:

Posted By: pmormr
Date Posted: 19 June 2003 at 2:56pm

-------------
Paul A Morgan

http://www.pmorganphoto.com/" rel="nofollow - http://www.pmorganphoto.com/

Posted By: pmormr
Date Posted: 19 June 2003 at 3:17pm

never mind, it used adOpenKeyset and it worked

-------------
Paul A Morgan

http://www.pmorganphoto.com/" rel="nofollow - http://www.pmorganphoto.com/