I'm trying to create a PostgreSQL prepared statement using node.js pg npm package. However, I keep getting an error:
could not determine data type of parameter $1
function promiseQuery(sql, values) {
return new Promise(function(resolve, reject) {
pool.query('select $1 from workers', ['name'], function(err, result) {
if (err) {console.log(err); reject(err)}
else resolve(result.rows);
})
});
}
In the db the name field is set to type text not null.
I also tries pg-promise, but with no success either.
via wizard
No comments:
Post a Comment