Hi Naveen,
Can you give me a sample code, or please modify the below code if possible,
because I am trying but did not find any success.
function getExternalLocation(cb) {
mssql.connect(msSqlSettings, function (err ) {
if (err) {
cb(err);
}
var getQuery = "SELECT [Title] FROM [dbo].[StyleTemplates] " ;
//console.log(getQuery);
var request = new mssql.Request();
// query to the database and get the data
request.query(getQuery, function (err, rows) {
mssql.close();
cb(err, rows);
});
});
} exports.eejsBlock_editbarMenuLeft = function (hook_name, args, cb) {
var userData = getExternalLocation(args, function(err, rows) {});
args.content = args.content +
eejs.require('ep_resources/templates/editbarButtons.ejs', {userData :
**userData** });
return cb();
})
On Wed, Jul 5, 2017 at 9:39 AM, Naveen Kerati <[email protected]>
wrote:
> Hi sushil ,
> why do you want to return values from a callback function . where you can
> pass the userdata from callback to ejs directly.
>
> On Sunday, July 2, 2017 at 5:36:46 AM UTC+5:30, Sushil Kumar Kishan wrote:
>>
>> I want to return database value in node js and pass as a variable in ejs
>> file.
>>
>> Bellow is the code, Which I used. *it did not return value.*
>>
>> function getExternalLocation(cb) {
>>
>> mssql.connect(msSqlSettings, function (err ) {
>> if (err) {
>> cb(err);
>> }
>> var getQuery = "SELECT [Title] FROM [dbo].[StyleTemplates] " ;
>> //console.log(getQuery);
>> var request = new mssql.Request();
>> // query to the database and get the data
>>
>> request.query(getQuery, function (err, rows) {
>> mssql.close();
>> cb(err, rows);
>> });
>> });
>> } exports.eejsBlock_editbarMenuLeft = function (hook_name, args, cb) {
>>
>> var userData = getExternalLocation(args, function(err, rows) {});
>> args.content = args.content +
>> eejs.require('ep_resources/templates/editbarButtons.ejs', {userData :
>> **userData** });
>> return cb();
>> })
>>
>> *Userdata* did not return any value;
>>
> --
> 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/1a9233d5-61bf-4e89-a10f-3fd12495f07f%40googlegroups.com
> <https://groups.google.com/d/msgid/nodejs/1a9233d5-61bf-4e89-a10f-3fd12495f07f%40googlegroups.com?utm_medium=email&utm_source=footer>
> .
>
> For more options, visit https://groups.google.com/d/optout.
>
--
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/CAK_QghWsYfvx7WAV03tpAALiT2zqW%3Df2d9gRBAC5uawp1dT%3D8g%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
