%$1% in db.run throwing errors and empty arrays
Created by: stevenmwade
I may just be using your syntax incorrectly, and if I am, I apologize.
This version gives an error bind message supplies 1 parameters, but prepared statement "" requires 0
:
db.run("select * from parts where name like '%$1%'", [name], function(err, parts) {
if(err) {
console.log('ERROR: ', err);
res.send(err);
} else {
res.send(parts);
}
});
This gives an empty array somehow:
db.run("select * from parts where name like '%$1%'", name, function(err, parts) {
if(err) {
console.log('ERROR: ', err);
res.send(err);
} else {
res.send(parts);
}
});
This works fine:
db.run("select * from parts where name like '%"+name+"%'", function(err, parts) {
if(err) {
console.log('ERROR: ', err);
res.send(err);
} else {
res.send(parts);
}
});