Small bug when querying with ORDER BY
Submitted by Code-Breaker on Mon, 2006-03-13 03:21.
EZ Results
I have found a curious bug that occurs when searching and using 'ORDER BY'. The following query displays correctly:
SELECT FName,LName FROM Customer WHERE FName LIKE '%tom%' OR LName LIKE '%tom%'
But if I try to order the results with:
SELECT FName,LName FROM Customer WHERE FName LIKE '%tom%' OR LName LIKE '%tom%' ORDER BY FName
ezresults will consistently report the correct number of matches, but list one fewer result than it should. The top-most result (first in the sort) is always missing. So for example, a result might be:
4 Results
Floyd Tomlinson
Harry Phantom
Tom Tupperware
4 Results
