jquery ajax call execute once function after complete

Question

I am in mobile app. I use ajax calls to receive data from webserver with this code:

            $.ajax({
                url: 'http://www.xxxxxxxxxxxx',
                data: {name: 'Chad'},
                dataType: 'jsonp',
                success: function(data){
                    $.each(data.posts, function(i,post){
                        $.mobile.notesdb.transaction(function(t) {
                        t.executeSql('INSERT into bill (barcode, buildingcode, buildingaddress, flatname, flatdescription, entryseason, period, amount, pastpayments, todaypayments, receiptno) VALUES (?,?,?,?,?,?,?,?,?,?,?);',
                            [post.Id, post.Code, post.Address, post.Name, post.Description, post.EntrySeason, post.Period, post.Revenue, post.PastPayments, post.todaypayments, post.receiptno],
                            function(){ 
                                bill = 1;
                                $('#mycontent').append("bill - OK");
                            }
                        );
                        });             
                    });
                }
            });

I want bill - OK displayed only once after all data inserted into sqlite.

bill - OK displayed for every insert to sqlite post... 20 times — kosbou
– kosbou, Commented Feb 22, 2012 at 20:51

komelgman · Accepted Answer · 2012-02-22 21:05:53Z

1

try this:

success: function(data){

    var count = data.posts.length;

    $.each(data.posts, function(i,post){
        $.mobile.notesdb.transaction(function(t) {
            t.executeSql(<...>,
                function() { 
                    bill = 1;
                    if (--count == 0) {
                        $('#mycontent').append("bill - OK");
                    }                        
                }
            );
        });             
    });
}

answered Feb 22, 2012 at 21:05

komelgman

7,0292 gold badges20 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

aletzo · Accepted Answer · 2012-02-22 20:59:12Z

0

try to add:

$.ajax({
    url: 'http://www.xxxxxxxxxxxx',
    data: {name: 'Chad'},
    dataType: 'jsonp',
    async: false, //this line here
    //...

EDIT

OK, what about:

$.each(data.posts, function(i,post){
    //rest of stuff
});

$('#mycontent').append("bill - OK"); //this line outside the each() call

edited Feb 22, 2012 at 20:59

answered Feb 22, 2012 at 20:50

aletzo

2,4661 gold badge27 silver badges31 bronze badges

2 Comments

kosbou Over a year ago

this way bill ok displed once but before insertion complete

aletzo Over a year ago

along with asynch: false line?

Collectives™ on Stack Overflow

jquery ajax call execute once function after complete

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related