SELECT * FROM table
WHERE field IN ($values)
Does anyone know how a SQLite prepared statement is expecting one to format the $values parameter here? I've tried setting
msg.params.$values to these strings:
As well as this array:
But none of them work... I'm guessing that something like:
WHERE IN ($valueA, $valueB)
might work. But if the number of items needed in the list varies, that isn't very helpful.
Is there not a way to do this with a prepared statement? Is creating the full SQL string and passing it to the node as
msg.topic the only way to do this?