Boomi, I really sorry that I didn't answer this question when you posted it
in the tedious group. I simply haven't had any proper spare time the last
few days.
I'm pleased that you got a good answer; better than one I might have
provided.
Mike
On Wednesday, 9 January 2013 07:37:13 UTC, 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
