Re: previous/next in sql

2001-04-04 Thread Brandon Paolin
- Original Message - From: "Russ Conway" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, April 04, 2001 3:38 PM Subject: RE: previous/next in sql > > alright, i'm trying to create a "previous/next" statement so that >

RE: previous/next in sql

2001-04-04 Thread Russ Conway
> alright, i'm trying to create a "previous/next" statement so that > my query only grabs 6 records at a time. How about using a cursor and submitting the ID of the last record processed as a parameter to the stored procedure? Then just loop through the results until you hit the ID passed to the