I'm in sqlite3 land and doing something like this is pretty simple:
var userQuery = SELECT * FROM USERS WHERE RECENT_USER = $recentUser;
And then I just go something like:
parameters.$recentUser = "Batman"
And I can easily run my SQL like this:
db.all(userQuery, parameters, function (err, rows){
data = rows;
});
Great. What happens when I want to try to do more than one user?
I thought of doing something like
parameters.$recentUser[0] = "Batman"
parameters.$recentUser[1] = "Robin"
and then dynamically generating a SQL statement like:
var userQuery = SELECT * FROM USERS WHERE RECENT_USER = $recentUser[0] OR RECENT_USER = $recentUser[1];
but I don't think this quite works. I get no results every time I do something like that. Any clues?
Thanks thanks thanks in advance!