Issue:Offset should be implemented at SQL level, not PHP

From FollowTheScore
Jump to: navigation, search
Description: Offset higher than max result limit outputs nothing
Extension / Version: DPL   /   1.5.1
Type / Status: Bug   /   closed

Problem

If Max results for DPL is set to 500, looking for results in range 600-800 is impossible. The reason being that the offset is implemented at PHP level, not SQL level.

Any reason for this, as Mysql offers [LIMIT {[offset,] row_count | row_count OFFSET offset}]

Reply

No reason for this, just my stupidness ;-). Maybe I find some time to change this by next week ...

Gero 17:27, 31 October 2007 (CET)

Fixed with version 1.5.2