Hi Kumar,
the operation "resultData = rows" is inside a callback, meaning it's in
another thread.
When "return resultData;" is read, it's still undefined, because it's being
processed in the callback.
The simple answer woulb be to just put the "return" in the callback, the
hard answer would be to understand how the main loop of nodejs works and
how to use promises for handling callback.
ps: use const or let instead of var :)
Calogero
On Sunday, 2 July 2017 02:06:46 UTC+2, Sushil Kumar Kishan wrote:
>
> Hi ,
>
> I am trying to display database value in a variable but does not return
> any value.
>
> below is the code.
>
> var mssql = require('mssql');
> var resultData='';
> function getStyleData(){
> var msSqlSettings = {
> server : 'localhost',
> port : '51663',
> user : 'sa',
> password : 'admin1234',
> database : 'ComWriter.Temp002'
> };
> mssql.close();
> mssql.connect(msSqlSettings, function (err ) {
> if (err) {
> throw (err);
> }
> var getQuery = "SELECT [Title] FROM [dbo].[Templates] " ;
> var request = new mssql.Request();
> request.query(getQuery, function (err, rows) {
> //console.log(rows);
> mssql.close();
> resultData = rows;
> });
> });
> return resultData;
> }
> var getFunction = getStyleData()
> console.log(getFunction);
>
--
Job board: http://jobs.nodejs.org/
New group rules:
https://gist.github.com/othiym23/9886289#file-moderation-policy-md
Old group rules:
https://github.com/joyent/node/wiki/Mailing-List-Posting-Guidelines
---
You received this message because you are subscribed to the Google Groups
"nodejs" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/nodejs/5bc10bd2-44a6-42cf-80d1-780b1bfa9613%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
