ionic-cordova-SQLite possible to insert a Array as parameter?

Question

I just wrote a simple function, that creates me a INSERT string out of the input the user has made, so I get something like this(working with ionic btw):

    INSERT INTO people(firstname, lastname) VALUES (??)

Now I would like to use a Array that holds the inputvalues as parameter:

let inputvalues = ["value1", "value2"];
    this.database.executeSql(this.createInserString("people",this.userData), [inputvalues]).then((data) => {
        console.log("INSERTED: " + JSON.stringify(data));
    }, (error) => {
        console.log("ERROR-Insert: " + JSON.stringify(error.err));
    });

Is there a way to implement something like this? (because otherwise I have to type out ever single input values and ... there are a lot ;-( )

Thank you!

Javad · Accepted Answer · 2017-08-06 07:10:52Z

4

+50

i think you should separate parameters with comma:

INSERT INTO people(firstname, lastname) VALUES (?,?)

and then use the array without "[ ]" since its already an array:

this.database.executeSql(this.createInserString("people",this.userData), inputvalues)

answered Aug 6, 2017 at 7:10

Javad

4471 gold badge5 silver badges15 bronze badges

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

1 Comment

user3793935 Over a year ago

Uh jeah, the comma was just a typo ;-) Thank you, that worked! Now I feel stupid ;D

Collectives™ on Stack Overflow

ionic-cordova-SQLite possible to insert a Array as parameter?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related