Postgres error: syntax error at or near ","

Question

i'm try to find error from my code but i dont know what i wrong. Can Anyone see some error on it?

const {Client} = require('pg');
const client = new Client({
user: 'me',
host: 'localhost',
database: 'printer',
password: '1234',
port: 5432,
});

client.connect(function(err){
if (err) throw err
console.log("Connected Successfuly");
console.log("****if you want to stop this service, press Ctrl + C****");

var datain ='{"filename" : "filetest01.pdf","printer" : "Microsoft Print to PDF","address" : "C:\\Users\\parun\\Desktop\\printer\\printerserver\\photo","date" : "2020-11-23T17:00:00.000Z","status" : 1}';
var sql = 'INSERT INTO print(filename, printer, address, date, status) VALUES(?, ?, ?, ?, ?)';

client.query(sql, [datain.filename, datain.printer, datain.address, datain.date, datain.status],(err, result) => {
        if (err)
            throw err;
        console.table(result.rows);
    });
});

datain is a string so datain.whatever will only ever be undefined. Remove the single-quotes if you want an actual object — Phil
– Phil, Commented Nov 30, 2020 at 4:36
@Phil ok, now im try t edit follow your comment but it's dont work and send me back to same my error — Kiazeed
– Kiazeed, Commented Nov 30, 2020 at 5:04
Can you indicate which line and column the error is at? Its easier to just post the full error stack trace — Paul Rooney
– Paul Rooney, Commented Nov 30, 2020 at 5:09

Tim Biegeleisen · Accepted Answer · 2020-11-30 06:02:45Z

1

change your sql

var sql = 'INSERT INTO print(filename, printer, address, date, status) VALUES($1, $2, $3, $4, $5)';

edited Nov 30, 2020 at 6:02

Tim Biegeleisen

526k32 gold badges324 silver badges399 bronze badges

answered Nov 30, 2020 at 5:33

yun

261 bronze badge

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Postgres error: syntax error at or near ","

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related