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]

Re: SQLite - total rows with limit and offset

On 29 Mar 2007 09:57:17 -0700, "C." <colin.mckinnon @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 :: andy@andyh.co.u k :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool