Difference between revisions of "Issue:Offset should be implemented at SQL level, not PHP"
From FollowTheScore
Line 4: | Line 4: | ||
|Version = 1.5.1 | |Version = 1.5.1 | ||
|Description = Offset higher than max result limit outputs nothing | |Description = Offset higher than max result limit outputs nothing | ||
− | |Status = | + | |Status = closed |
}} | }} | ||
Line 15: | Line 15: | ||
No reason for this, just my stupidness ;-). Maybe I find some time to change this by next week ... | No reason for this, just my stupidness ;-). Maybe I find some time to change this by next week ... | ||
:[[User:Gero|Gero]] 17:27, 31 October 2007 (CET) | :[[User:Gero|Gero]] 17:27, 31 October 2007 (CET) | ||
+ | |||
+ | Fixed with version 1.5.2 |
Latest revision as of 07:47, 3 November 2007
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