SQLite - total rows with limit and offset

[C.]

Hi,

First off, apologies for posting here - I can't find a dedicated
SQLite newsgroup

The other thing I can't find is how to retrieve the total number of
rows which would have been returned by a query if it did not have a
LIMIT and/or OFFSET clause.

(kind of like SQL_CALC_FOUND_ROWS/FOUND_ROWS() in MySQL)

TIA

C.

[Andy Hassall]

On 29 Mar 2007 09:57:17 -0700, "C." <co************@gmail.comwrote:

>First off, apologies for posting here - I can't find a dedicated
SQLite newsgroup

The other thing I can't find is how to retrieve the total number of
rows which would have been returned by a query if it did not have a
LIMIT and/or OFFSET clause.

(kind of like SQL_CALC_FOUND_ROWS/FOUND_ROWS() in MySQL)

I don't see one from a quick flick through the manual - you'll probably have
to issue another similar query with a count(*) and no limit clause.

--
Andy Hassall :: an**@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool