That is it! Thank you so much..
On Thu, Jan 10, 2013 at 4:52 AM, Andrew Maurer <[email protected]> wrote: > You need to res.send() in the new Request() constructor. I know, it isn't > clear that the callback is actually what happens when the request is > complete. > > So before "connection.close();" send your payload. In your "row" event, > collect your results. Here is some sample code I wrote a few days ago > (ironically, I too just picked up Tedious.) > > var results = []; > > var conn = new Connection(connectionObject); > conn.on("connect", function(){ > var r = new Request("exec andrew.dbo.usp_getLogEntriesByDay", function(){ > res.set({ > 'Expires' : new Date(Date.now() + 900000) > }) > res.json(results); > }); > r.on("row",function(row){ > results.push({ > countof : Number(row[0].value), > createdDateTime : new Date(row[1].value).getTime() > }); > }); > this.execSql(r); > }); > > > > On Wednesday, January 9, 2013 2:37:13 AM UTC-5, Bhoomi Kakaiya wrote: >> >> >> Hi all, >> >> I am pretty new to Node. I am using Tediuos to get data from SQL >> database. >> >> Here is the code snippet : >> >> app.get('/getitems', function(req, res){ >> res.contentType('application/**json'); >> var config = { userName: 'sa', password: 'pass', server: >> '127.0.0.1', options : { database:'Auto'} >> }; >> var connection = new Connection(config); >> connection.on('connect', function(err) { >> executeStatement(res); >> }); >> function executeStatement(res1) { >> console.log(res1.contentType)**; >> request = new Request("select top 3 sItemId [Id], sName [Item], nrate1 >> [Rate] from bmitem", function(err, rowCount) { >> if (err) { >> console.log(err); >> } else { >> console.log(rowCount + ' rows'); >> } >> connection.close(); >> }); >> >> request.on('row', function(columns) { >> columns.forEach(function(**column) { >> if (column.value === null) { >> console.log('NULL'); >> } else { >> console.log(column.value); >> } >> }); >> }); >> request.on('done', function(rowCount, more) { >> console.log(rowCount + ' rows returned'); >> debugger; >> res1.send("3");// Here is the problem. Debugger shows res1 is <error>. >> }); >> connection.execSql(request); >> } >> }); >> >> >> The problem is response object has error. >> I want to create json of the items returned from db and want to pass it >> as json in the ajax request. >> >> If I return response in request.on("row") it works. Do not understand why >> response object is not available on "done" event. >> >> Thanks in advance. >> >> Bhoomi. >> >> >> -- > Job Board: http://jobs.nodejs.org/ > Posting guidelines: > 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 post to this group, send email to [email protected] > To unsubscribe from this group, send email to > [email protected] > For more options, visit this group at > http://groups.google.com/group/nodejs?hl=en?hl=en > -- Job Board: http://jobs.nodejs.org/ Posting guidelines: 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 post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nodejs?hl=en?hl=en
