app.get('/samples/:id', function(req, res) {
db.query("select meta from Samples where sample_id = ?", [req.params.id], function(err, rows, moreResultSets)
{
res.header("Content-Type", "text/xml");
res.send(rows[0].meta);
util.debug(util.inspect(rows));
});
});
db2client.open(connString , function(err){
if(err){
cb(err, undefined);
} else {
db2client.query("call "+schema+"."+procedure+"("+"?".concat(Array(array.length).join(",?"))+")", array, function (err, rows) {
if(err){
cb(err, undefined);
} else {
db2client.close(function () {
cb(null, rows);
});
}
})
}
})
db.open(cs, function(err){
var sql = "select foo, bar from HOGE order by foo";
db.query(sql, function(err, rows, rs){
//console.log(rows);
var i=0;
for (i=0; i<rows.length; i++) {
console.log([
i,
rows[i]["foo"],
rows[i]["bar"]
].join(", "));
}
db.close(function(){
console.log("close.");
});
});
});
db2client.open(connString , function(err){
if(err){
cb(err, undefined);
} else {
var colStrList = "*";
var conditions = "";
if(colName)
colStrList = generateCol(colName);
if(options)
conditions = generateConditions(options);
db2client.query("select "+colStrList+" from "+ tableName+conditions, function (err, rows) {
if(err){
cb(err, undefined);
} else {
db2client.close(function () {
cb(null, rows);
});
}
})
}
})