nodejs sql error Error converting data type varchar to int

sorry about my english i have error from sql server "Error converting data type varchar … Read more nodejs sql error Error converting data type varchar to int

sorry about my english i have error from sql server "Error converting data type varchar to int"

my code js

exports.Checkskip = async function(req, res) {
try {
    let a = req.params.TagAlternateKey;
    let b = req.params.ProcessOfProductionKey;
    const pool = await poolPromise;
    const result = await pool.request()
        .query("execute [wos].[StoredInternalProcessTransactionCheckProcessBeforeReceiving ] '"+req.params._TagAlternateKey+"','"+ req.params._ProcessOfProductionKey +"' ",function(err, result)
        {   
            if (err) {
                console.log(err)
            }
            else {
                res.json(result.recordset); 
            }
        })
}catch (err){
    res.status(500)
    res.send(err.message)
}
}

my data for input
can you help me

Source: JavaSript – Stack Overflow



Leave a Reply

Your email address will not be published. Required fields are marked *