Issue with insert query in Sqlite ?( variable insert)

Question

How can I insert variable value in Sqlite, I am unable to find the issue with my code, If I use insert statement as follows it is working and values are inserted,

tx.executeSql('INSERT INTO Locationlog (Coordinates, Location, Category, Address) VALUES ("manju", "kishor", "ramesh", "ram")');

If I try to insert as follows the values are not inserted,

tx.executeSql('INSERT INTO Locationlog (Coordinates, Location, Category, Address) VALUES (?,?,?,?)',[Latlongs,Location,Category,Address]);

does not work for the query like,

 tx.executeSql('INSERT INTO Locationlog (Coordinates, Location, Category, Address) VALUES ('+Latlongs+', '+Location+', '+Category+', '+Address+')');

I am using TEXT as datatype for all columns, the input value size is in between 1-100. What is the maximum size for TEXT data type? Any one can suggest how to insert variables in insert query ?

var Latlongs = $("#defendLatlongs").val();
   var Location = $("#defendLocation").val();
   var Category = $("#defendcategory").val();
   var Address = $("#defendAddress").val();

   var db = window.sqlitePlugin.openDatabase({name: "MYDB"});
   db.transaction(function (tx) {
   tx.executeSql('CREATE TABLE IF NOT EXISTS Locationlog (Coordinates TEXT, Location TEXT, Category TEXT, Address TEXT)');
     });
  db.transaction(function (tx){
  tx.executeSql('INSERT INTO Locationlog (Coordinates, Location, Category, Address) VALUES (?,?,?,?)',[Latlongs,Location,Category,Address]);


 });

 });

suganthi · Accepted Answer · 2014-04-02 08:23:12Z

3

add id attribute

var db = window.sqlitePlugin.openDatabase({name: "MYDB"});
db.transaction(function (tx) {
tx.executeSql('CREATE TABLE IF NOT EXISTS Locationlog (id INTEGER PRIMARY KEY AUTOINCREMENT,Coordinates TEXT,    Location TEXT, Category TEXT, Address TEXT)');
 });
db.transaction(function (tx){
tx.executeSql('INSERT INTO Locationlog (Coordinates, Location, Category, Address) VALUES (?,?,?,?)',   [Latlongs,Location,Category,Address]);

answered Apr 2, 2014 at 8:23

suganthi

3601 silver badge12 bronze badges

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

Collectives™ on Stack Overflow

Issue with insert query in Sqlite ?( variable insert)

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related