code

function getIdCPS(ricovero){

    console.log("getIdCPS()");
    querySQL = "SELECT id FROM codici_pronto_soccorso WHERE codice ='"+ricovero.cps+"'";
    console.log("querySQL="+querySQL);

    return new Promise(function(resolve, reject){

        if(ricovero.cps != ""){

            try{

                connection.query(querySQL, function(err, result) {

                    if(err){

                        console.error(err);
                        reject();

                    }else{

                        console.log("result is defined");
                        console.log("result=("+result+")");

                        resolve( result[0].id);

                    }

                });

            }catch(e){

                console.log("try/catch error:" + e);
                reject();

            }

        }else
            resolve("");

    });

}