Ionic Sqlite : insert dynamic array into table

Question

I am trying to insert an array into my sqlite database. But all the data is getting inserted into the first column. Please help. I already checked these :

https://github.com/litehelpers/Cordova-sqlite-storage/issues/392

sqlite3 insert into dynamic table

But not able to solve my problem.

my code is

 let insertarr:Array;

for(var i=0;i<this.fullData.length;i++)

{
insertarr = [];
for(var j=0;j<this.fullData[i].length;j++)
{

        insertarr.push(this.fullData[i][j].val);

      }
     alert(insertarr);
      db.executeSql('insert into mytable (col1, col2, col3) values(?,?,?)', [insertarr]);  
  }

When I run the above code col1 is getting populated with the full array. col2 and col3 are populated with null.

I want to insert the array. the array have 3 elements and my table have 3 columns. — Arijit
– Arijit, Commented Jul 8, 2017 at 3:03
You have an array with 3 element and want to insert each element to a column right? — Duannx
– Duannx, Commented Jul 8, 2017 at 4:00

Arijit · Accepted Answer · 2017-07-08 13:08:44Z

1

Solved this issue. Posting if it helps someone in future.

I changed the arguments of db.executeSql like below:

 db.executeSql('insert into mytable (col1, col2, col3) values('+insertarr+')', {});

answered Jul 8, 2017 at 13:08

Arijit

1,7053 gold badges22 silver badges35 bronze badges

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

Collectives™ on Stack Overflow

Ionic Sqlite : insert dynamic array into table

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