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
Post a Comment