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/fdc2cf76-669a-44e1-b99d-ed0405d4e137%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
