i want to insert a a set of data in a local db (webSQL) but the data is not inserted
hear is my code:
app.js :
$scope.insert=function(selected){
/* $scope.selected =[];/
var query=“INSERT INTO contact(displayName,phoneNumbers) VALUES (?,?)”;
$cordovaSQLite.execute(db,query,[selected.displayName,selected.phoneNumbers]).then(function(res){
/$cordovaSQLite.execute(db,query,[selected]).then(function(res){*/
alert($scope.status=“contacts sucess”);
console.log("insertId: " + res.insertId);
},function(err){
alert($scope.status="contact login :" +err.message);
});
}
hear is my array list:
$scope.selected =[];
$scope.exist = function(item) {
return $scope.selected.indexOf(item) > -1;
}
$scope.toggleSelection = function(item){
var idx = $scope.selected.indexOf(item);
if(idx > -1){
$scope.selected.splice(idx, 1);
}
else{
$scope.selected.push(item);
}
}