how to get data from web services in my SQLite insert field .
i have 29 field in my json and i am using asp.net web serveces
my database table is this. ->
document.addEventListener(‘deviceready’, function() {
db = $cordovaSQLite.openDB(“my.db”);
$cordovaSQLite.execute(db, "CREATE TABLE IF NOT EXISTS my.db (id integer primary key,AMPS,Application,CLAWS,DriveOD,HEIGHTOFSTACK,KW,Length,OAL,Rotation,RotationDrive,RotationMoter,SEGMENTS,SPLINE,TERMINALS,Teeth,TeethID,TeethOD,VOLT,brand,catid,cattitle,coil,oemno,oemtitle,prodcode,prodcode1,prodid,status,uploadImage)");
console.log(db);
});
var execute = function() {
var query = "INSERT INTO my.db (AMPS,Application,CLAWS,DriveOD,HEIGHTOFSTACK, KW,Length,OAL,Rotation,RotationDrive,RotationMoter,SEGMENTS,SPLINE, TERMINALS,Teeth,TeethID,TeethOD,VOLT,brand,catid,cattitle,coil,oemno,oemtitle,prodcode,prodcode1,prodid,status,uploadImage) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
$cordovaSQLite.execute(db, query, ["AMPS", "Application", "CLAWS", "DriveOD", "HEIGHTOFSTACK", "KW", "Length", "OAL", "Rotation", "RotationDrive", "RotationMoter", "SEGMENTS", "SPLINE", "TERMINALS", "Teeth", "TeethID", "TeethOD", "VOLT", "brand", "catid", "cattitle", "coil", "oemno", "oemtitle", "prodcode", "prodcode1", "prodid", "status", "uploadImage"]).then(function(res) {
console.log("insertId: " + res.insertId);
}, function (err) {
console.error(err);
});
};