-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 07/10/11 18:52, Simon Slavin wrote: > I'll just use LIMIT 51 on my query and if I get 51 results back I'll > know there are too many for the query to be useful.
Incidentally you don't need to add a limit on the query. In the code that calls sqlite3_step just track if the 51st consecutive call returns SQLITE_ROW or SQLITE_DONE. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAk6Py9QACgkQmOOfHg372QROzgCglOXXEa6lkXWZx99VCsZpg52m 4XIAoIcfYhVKlus34jq3zpw+QS9SNkV3 =Nf1K -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
