Hi. I try to read an array from MSSQL database and insert the Array data into a postgresql database. From the postgres node I get the "Error: msg.payload must be an array of queries".
The Output from mssql is an Array
the function node has follow Content:
var newMsg = { payload: msg.payload.length };
return newMsg;
var i;
var sql="";
var outputs=[];
var TagNumber;
var KeeperID;
for (i = 0; i< msg.payload.length; i++) {
TagNumber=msg.payload.Rows[i].TagNumber;
KeeperID=msg.payload.Rows[i].KeeperID;
sql="INSERT INTO test_garment"+
"VALUES (\""+TagNumber+"\",\""+KeeperID+"\");";
outputs.push({topic:sql});
}
I dint see whats wrong ...