How the stored procedure should be when the OnScroll feature is used with server side processing?
How the stored procedure should be when the OnScroll feature is used with server side processing?
chaturvedi_anshumaan
Posts: 25Questions: 5Answers: 0
I have this question in my mind what special parameters or methods should be implemented while writing stored procedure for display of data in Brwoser, given the condition 
1. Using serverSide Processing set to true in jQuery DataTable
2. Using the onScroll feature of jQuery datatable.
This discussion has been closed.
Answers
Is this a duplicate question of your other thread?
The same answer applies that Colin provided. Your server script needs to use something like SQL LIMit and OFFSET to page (limit) the data returned to the server. Once you get your server script to handle the Server Side Processing protocol then using Scroller will be easy.
Kevin