On Wed, Apr 28, 2010 at 7:30 AM, Alexey Pechnikov <[email protected]>wrote:
> 2010/4/28 Manoj M <[email protected]>: > > I am getting error message "near "?": syntax error" randomly while > > executing the query "SELECT [record] FROM [ac_contacts_cache] LIMIT 0, > > 3". > > The SQL "LIMIT 0, 3" is incorrect. Use "LIMIT 3 OFFSET 0" instead. > SQLite accepts both variations on the LIMIT syntax. They do exactly the same thing. Manoj has an application problem of some kind. He is sending something to sqlite3_prepare() that is different from what he things he is sending. Or, perhaps he has multiple threads running with SQLite mutexes disabled. Or prehaps he is send a string into sqlite3_prepare() and then freeing and/or overwriting that string before sqlite3_prepare() returns. In any event, it is not SQLite that is causing Manoj's problem, and without additional information, we can't really determine the source of the problem. > > -- > Best regards, Alexey Pechnikov. > http://pechnikov.tel/ > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- --------------------- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
