I'm curious how folks are implementing pagination using SQL Server 2000 and avoiding returning entire recordsets to CF.
In other words, if I have a search result set of 1,000 rows, and the user will be walking through that recordset 25 rows at a time using <prev> <pagenumbers> <next> methods, how are folks limiting the result set to only the current 25 rows needed to display.
Thanks,
Calvin
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
