Tuesday 30 May 2017

Escape question mark characters as placeholders for MySQL query in NodeJS

I have the following query that I'm using in the query function (https://github.com/mysqljs/mysql#escaping-query-values) :

database.query("UPDATE Project SET Content = 'Hello ?' WHERE Id = ?", [id], function(err, rows, fields) {
        if (err) {
            console.log(err);
            res.json({ status: 'FAIL QUERY' });
        } else {
            res.json({ status: 'SUCCESS' });
        }
    });

I have an error because it is replacing the question mark on "'Hello ?'" and "WHERE Id = ?" and he only have one attribute : [id]. How to avoid this ?



via Pierre Bressand

No comments:

Post a Comment