how do I check the empty result

[bobchennan]

I use query.on('row') to get the result.But if the result is empty,then how can I know it?
Because NodeJS is Asynchronous execution,I can't just write as this:
db.query("").on('row',function(r){
});
res.write('error');

So what I should do instead of?

[sidorares]

function getNumRowsInResult(db, sql, callback)
{
    var rowCount = 0;
    db.query(sql)
        .on('row', function() { rowCount++; })
        .on('end', function() { callback(rowCount); });
}

[bobchennan]

Thanks a lot.

2012/2/25 Andrey Sidorov <
[email protected]

function getNumRowsInResult(db, sql, callback)
{
var rowCount = 0;
db.query(sql)
.on('row', function() { rowCount++; })
.on('end', function() { callback(rowCount); });
}

---

Reply to this email directly or view it on GitHub:

#56 (comment)

QQ:404692150