DataTables / Editor-PHP

PHP server-side libraries for Editor
Other
35 stars 22 forks source link

Fix pagination for oracle driver #22

Closed chrostek closed 1 year ago

chrostek commented 1 year ago

see https://stackoverflow.com/questions/30321483/how-rownum-works-in-pagination-query
or https://asktom.oracle.com/Misc/oramag/on-rownum-and-limiting-results.html old implementation did not work

AllanJard commented 1 year ago

Fantastic - many thanks for this!

scollovati commented 1 year ago

Tested with Oracle. This solves the issue!