Skip to main content
N
nedflanders
Participant
October 26, 2006
Question

MS SQL Recordset paging (on DB server)

  • October 26, 2006
  • 1 reply
  • 564 views
I have a DB (MS SQL) that has over 300,000 records (and growing) and i would like to allow paging results on the CF output page but i dont want CF to have to do all the work. Does anyone have a StoreProcedure for MS SQL to do recordset paging server side? i have seen some examples online but they dont seem complete.

thanks
ned
This topic has been closed for replies.

1 reply

T
The_ScareCrow
Inspiring
October 26, 2006
Hi Ned,

I have a sp that does this. As soon as I get home I will post.

Ken
T
The_ScareCrow
Inspiring
October 27, 2006
Ned,
I can't really post the sp as it has a lot of client info. Even though no one could identify the client.

So, if you email me at info@krcaldwell.com
I will explain how the sp works and send you a copy of the sp.

Ken
T
The_ScareCrow
Inspiring
October 28, 2006
Ned,

I put together a sample for you.
See attached code (complete sp)

Ken
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices