On Sat, 21 Aug 2004, WysG wrote: > Well no that's not true, I found a "sloppy way" of getting the number of > row, that is executing the same query 2 times, once with sqlite3_exec > and a callback that does oRs->intRecordCount++ and then with > sqlite3_prepare to get the vm > > Is that the only way to get the record count ?
Either that, or calling the SQL first with count(). SQLite's vm doesn't know the number of rows until it's looped through all the rows. It can't by design IIRC. Matt. ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________
