Thanks for all help. Yes, its an application issue. We fixed it. Regards, Manoj Marathayil
On Wed, Apr 28, 2010 at 5:16 PM, Richard Hipp <drhsql...@gmail.com> wrote: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users