function getallTableData(tx) { tx.executeSql('SELECT * FROM CaseTable', [], querySuccess, errorCB); } function querySuccess(tx, result) { var len = result.rows.length; var countDoument=0 $('#folderData').empty(); for (var i = 0; i < len; i++) { alert(i) // here value is i =0 test1=result.rows.item(i).CaseName; Test1(test1,function(result_count){ countDoument=result_count; // here it count value alert(result_count+"result_count") //alert is correct count value alert(i+"i"); //here i comes 1 why ? it should be 0 $('#folderData').append( '<li class="caseRowClick" id="' + result.rows.item(i).id + '" data-rel="popup" data-position-to="window">' + '<a href="#">' + '<img src="img/Blue-Folder.png">' + '<h2>' + result.rows.item(i).CaseName +countDoument+'</h2>' + '<p>' + result.rows.item(i).TextArea + '</p>' + '<p>' + result.rows.item(i).CaseDate + '</p>' + '</a>' + '<span class="ctrl togg"><fieldset data-role="controlgroup" data-type="horizontal" data-mini="true" ><button class="edit button_design">Edit</button><button class="del button_design">Delete</button></fieldset><span>'+'</li>' ); }); $('#folderData').listview('refresh'); } } function Test1(test, callBack){ var x; db.transaction(function (tx) { $yoursql = 'SELECT * FROM "'+test+'" '; tx.executeSql($yoursql, [], function (tx, results) { x = results.rows.length + "TableName" + test; callBack(x); }); }); }
for (var i = 0; i < len; i++)
for (var i = 0; i < len-1 ; i++)
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)