[EMAIL PROTECTED] wrote:
> This issue keeps coming up so I did a wiki page.
> http://www.sqlite.org/cvstrac/wiki?p=ScrollingCursor
I'm using the method described in the wiki and it was working pretty
well until I hit a data set where the sorting column was not unique.
Here is the query from the wiki:
SELECT title FROM tracks
WHERE singer='Madonna'
AND title<:firsttitle
ORDER BY title DESC
LIMIT 5;
Imagine if several songs have the same title -- this could happen, for
example, if the ID3 tags are messed up ('untitled', 'untiled') or if the
user has several versions of the same song. Using this query, we'll end
up skipping over all the songs with the same title.
Any thoughts on how to handle this?
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
