On Wed, Apr 28, 2010 at 7:30 AM, Alexey Pechnikov <pechni...@mobigroup.ru>wrote:
> 2010/4/28 Manoj M <manojmaratha...@gmail.com>: > > 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 > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- --------------------- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
