sql - Getting data in an API from a Stored Procedure in javascript -


so title may not helpful.. using microsoft azure call stored procedure

mssql.query("exec allinfo ?", [meetingid],       {         success: function(results1) {                         console.log(results1);              var endoutput2 = request.body.meetingname;              response.send(statuscodes.ok, endoutput2 );        },       error: function(err) {             console.log("error is: " + err);             response.send(statuscodes.ok, { message : err });       }     }); 

i know line

var endoutput2 = request.body.meetingname;  

is not correct. trying result executing stored procedure allinfo. how can data can parse , use later in project. stored procedure below.

begin  select * scheduleme.main_meeting  meetingid = @meetingid;  select * scheduleme.date_time meetingid = @meetingid;  end 

i can output this(below) cannot grab meetingname or other variables.

[{"meetingid":"899c-64b7-fa94","meetingname":"test 1","meetingdescription":"test","meetinglength":30,"meetingnotes":null,"hostuserid":"someone@hotmail.com"}] 

you can result result1 variable.

in order first meetingname returned can do

results1[0].meetingname 

although it's best check if array returned has elements work better

var endoutput2 = null; if (results1.length)     endoutput2  = results1[0].meetingname 

Comments

Popular posts from this blog

python - Specify path of savefig with pylab or matplotlib -

How to run C# code using mono without Xamarin in Android? -

html - grunt SVG to webfont -