Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- SQLite - total rows with limit and offset
March 29, 2007, 4:57 pm
rate this thread
First off, apologies for posting here - I can't find a dedicated
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)
Re: SQLite - total rows with limit and offset
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 :: firstname.lastname@example.org :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool