"Dieter Guthmann" <mailing-...@bup-nbg.de> wrote in message news:49d0ac6b.60...@bup-nbg.de > -- 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 sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
