"Dieter Guthmann" <[email protected]> wrote in message news:[email protected] > -- Statement for whole list: > SELECT manufacturer, model_name FROM device ORDER BY manufacturer; > > -- Statement sent by application for the second scrolling step (should > show row 4 to 6): > SELECT manufacturer, model_name FROM device WHERE manufacturer > 'M2' > ORDER BY manufacturer LIMIT 3; > > The first problem is that the second page should start with ( M2 | > X500 ) but the where clause causes that all rows with > manufacturer="M2" are omitted. > If I use two columns in the where-clause the output still gets worse: > ...WHERE manufacturer > 'M2' AND model_name > 'X1000'... > also omitts the row ( M3, X1000 ).
You want something like this: SELECT manufacturer, model_name FROM device WHERE manufacturer >= 'M2' AND (manufacturer > 'M2' OR model_name > 'X1000') ORDER BY manufacturer, model_name LIMIT 3; Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
