javascript - 在node.js中从mySQL删除时出错

Question

在将参数发送到我的方法时，我收到一个我不明白的错误，我认为我的查询是错误的，但我手动执行了它，并且 mySQL 做了它必须做的事情。所以问题出在我的代码中，但我似乎找不到哪里，提前谢谢。

exports.defav = function(id_user, id_restaurant, callback){

console.log(id_user + " " + id_restaurant); //Just making sure i'm reciving correclt
pool.getConnection(function(err, connection){
  if(err){
    console.log(err);
    callback(true);
    return;
  }

  connection.query("DELETE FROM favorites WHERE id_user = ? AND id_restaurant = ?", id_user, id_restaurant, function(err, results) {
    console.log("SUCCESS: Removed from fav ");
    connection.release();
      if(err){
        console.log(err);
        callback(true);
        return;
      }

      callback(results);
    });
  });
};

我收到的错误是:

throw err; // Rethrow non-MySQL errors ^

TypeError: this._callback.apply is not a function

Answer 1

查询参数应以数组形式传递:

connection.query("DELETE FROM favorites WHERE id_user = ? AND id_restaurant = ?", [ id_user, id_restaurant ], function(err, results) {
  ...
});