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

Reply via email to