When I attempt to prepare the following statement using sqlite3_prepare:

   SELECT id FROM testEntity LIMIT 5 OFFSET ?;

I get the following error back from SQLite:

   near "?": syntax error

Is this really not allowed? If so, that seems a bit odd to me. This seems like a classic use-case for prepared statements (re-running the same query with different offsets).

Or is there something else I'm missing?

-Eric


(FWIW, I'm using SQLite 3.0.8 on Mac OS X.)



Reply via email to