Error making an SQL query with JavaScript

2

I'm trying to do a SELECT from node.js to get an error from a table of "errors" but I get the following error and I do not know what else to do or what is due.

  

UnhandledPromiseRejectionWarning: RequestError: Could not find stored   procedure 'S @ param1L'.

This is the code I use:

function BD_Connection(err){
  var conn = sql.connect(config, function(err, request){
    var message = "Codigo error: BD0001 \nDescripcion: Error al conectar con la base de datos \nFuncion: BD_Connection()";
  if(err) {
    //throw new error(message);
    console.log(err)
  }else{
    conn.query("SELECT * FROM Error WHERE Error_Code = DB0002",function(err, result){
      if(err){
        console.log("Error")
      }else{
        console.log(result)
      }
    })
  }
  })
}

In this method I call that function:

app.listen(3001, function(err, res){
  if(err){
    console.log("Error")
  }else{
    console.log('Im listening');

  }  
  let fs = require('fs');

fs.readFile('config/config.txt', 'utf-8', (err, data) => {
  if(err) {
    console.log('error: ', err);
  } else {
    var NewConfig = JSON.parse(data);
    config = NewConfig;
    BD_Connection("DB0002");
}
});
});

Does anyone know what is due? Thanks.

    
asked by java005 02.10.2018 в 00:43
source

0 answers