On Fri, Oct 16, 2009 at 12:58 PM, Simon Slavin <slav...@hearsay.demon.co.uk> wrote: > > On 16 Oct 2009, at 8:53pm, P Kishor wrote: > >> If neither the username nor the email exist in the db, then the >> application creates a record and informs the user of success. Except, >> the previous ajax request (I am assuming it is the previous ajax >> request from onblur event from the email field) has locked the >> database, and the app returns an error that "the database is locked." >> >> So, what suggestion might you all have for getting around this? > > You're using AJAX ? That means JavaScript. Put a 3 second pause into > the routine that returns the query about the email field. 3 seconds > should be enough to get the database unlocked.
What if two users sign up at the same time? Javascript surely wouldn't help. Stephan > Simon. > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Stephan Wehner -> http://stephan.sugarmotor.org (blog and homepage) -> http://loggingit.com -> http://www.thrackle.org -> http://www.buckmaster.ca -> http://www.trafficlife.com -> http://stephansmap.org -- http://blog.stephansmap.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users