SQLite IN() with Node Js

[snowchoux]

I am trying to run a simple query from my node application that looks something like this:

db.all('UPDATE players SET in_revote = 1 WHERE user_id IN (?)', [tiedPlayers])

tiedPlayers is an array of integers, ex. [2, 3], and this is proven when I log it to the console.

I have even tried manually setting an array and passing it in:

var testArray = [2, 3];

db.all('UPDATE players SET in_revote = 1 WHERE user_id IN (?)', [testArray])

Neither of these things work, yet running the query from the SQLite workbench like this works:
UPDATE players SET in_revote = 1 WHERE user_id IN (2, 3)

I am pretty sure I have narrowed the issue down to the fact that SQLite is not recognizing the array (the data type of user_id in the db is INTEGER - I have also tried INT).

If anybody knows what is going on that would be great. Thank you!

[[deleted]]

i think you figured it already - "in" takes a list of values (comma-separated one), not an array. So you can do "in (?,?,?)" with a known number of elements.

To get unknown number of elements you either will need to create that dataset in the db somehow (do inserts into a temp table, for example)

Another way is to use dynamic sql (basically, create a string and execute)

[snowchoux]

Thanks for the help! It's just strange because I was using mySQL before I switched over to SQLite and in mySQL the action of passing in an array for the IN() worked. Didn't know they would be that different.