Node-sqlite3: can we pass param in select * from table in?

[angelochen960]

Hi,
this works:

db.get("select * from sample where number in ( '0136', '5431', '5448', '0136' )", function(err, rslt) {
    console.log(rslt)
})

but this won't, any way to pass parameters into query in situations like this?

var sel = [ '0136', '5431', '5448', '0136' ]

db.get("select * from sample where number in ? ",  sel, function(err,  rslt) {
    console.log(rslt)
})

[lvivier]

Unfortunately this doesn't work, values bound to parameters have to correspond to SQLite types: Strings, Numbers, Booleans, null. Also, sel is an array and gets interpreted as a list of parameter values rather than one value. If you know the length of sel you can have a statement like:

select * from sample where number in (?, ?, ?)

If sel has a variable length you'll have to stick together a valid statement somehow:

var sel = [5431, 5448]

function inParam (sql, arr) {
  return sql.replace('?#', arr.map(()=> '?' ).join(','))
}

db.all(inParam('select * from sample where number in (?#)', sel), sel, function(err, rslt){
  console.log(rslt)
})

[rns4731]

+1 for supporting "IN"

[Houfeng]

+1，need "IN" supoort

[rdcdev]

Using string interpolation:

db.get(`select * from sample where number in (${sel.map(_ => '?')})`, sel, function(err, rslt) {
console.log(rslt)
})