Hello
I am adding some data on data base problem After adding i need to show on list view.I need to remove all data from list before rendering again .how to remove data from list?
Hete is my code
$(document).ready(function() {
$.mobile.loading('hide');
onDeviceReady();
});
var db = "";
function onDeviceReady(){
db = window.openDatabase("Casepad", "1.0", "Casepad", 200000);
db.transaction(queryDB,errorCB);
}
function insertData(){
db.transaction(populateDB, errorCB, successCB);
}
function populateDB(tx) {
tx.executeSql('CREATE TABLE IF NOT EXISTS CaseTable (id INTEGER PRIMARY KEY AUTOINCREMENT, CaseName TEXT NOT NULL,CaseDate INTEGER ,TextArea TEXT NOT NULL)');
tx.executeSql('INSERT INTO CaseTable(CaseName,CaseDate,TextArea) VALUES ("'+$('#caseNameValue').val()+'", "'+$('#caseDate').val()+'","'+$('#caseTextArea').val()+'")');
}
function errorCB(err) {
alert("Error processing SQL: "+err.code);
}
function successCB() {
alert("success!");
db.transaction(queryDB,errorCB);
}
function queryDB(tx){
tx.executeSql('SELECT * FROM CaseTable',[],querySuccess,errorCB);
}
function querySuccess(tx,result){
var len = result.rows.length;
for (var i=0; i<len;> $('#folderData').append(
'<ul><li class="row" id="' + i + '">' + '<a href="#">' + '<img src="img/Blue-Folder.png">' + '<h2>'+result.rows.item(i).CaseName+'</h2>' + '<p>'+result.rows.item(i).CaseDate+'</p>' + '<p>'+result.rows.item(i).TextArea+'</p>'+'<span class="ui-li-count">'+ i+'</span></a>' + '</li></ul>'
);
}
$('#folderData').listview('refresh');
}
$("#Cancel").click(function() {
$('.ui-dialog').dialog('close')
$.mobile.changePage($("#Home"), {
transition: "pop",
reverse: false,
changeHash: false
});
});
$("#CancelSettingButton").click(function() {
$.mobile.changePage($("#Home"), {
transition: "slide",
reverse: false,
changeHash: false
});
});
<!--<-------------------Cancel Button Functionality End----------------------------------------->-->
<!-----------------------Add Button Functionality---------------------------------------------------->
$("#AddButton").click(function() {
var isvalid=true;
if(isvalid){
insertData();
$.mobile.changePage($("#Home"), {
transition: "slide",
reverse: false,
changeHash: false
});
}
});