node.js - How to access mysql stored procedure out parameter in the nodejs code -

node.js - How to access mysql stored procedure out parameter in the nodejs code -

phone call mysql stored procedure in , out parameter in node js code

connection.query("call vts_active_tagid('"+rfidnumber+"','"+latitude+"','"+longitude+"','"+datetime+"','"+imeno+"',@passengers,@trip)"); how @passenger , @ trip value in code

you can use:

db_ask.query(("set @a = 0; phone call login('" + _useremail + "','" + _password + "', @a); select @a;"),function(err, results){ //process result }

assuming _useremail , _password parameters given in js function , @a int defined in stored procedure.

node.js