CONVERT DATABASE OBJECT IN STRING

[Nilton Cezar]

Hello guys,

Using a select to query my sql server, the result is an object. But I can not use the result as a string. what am I doing wrong?

I've tried the function

msg.payload = msg.payload[0].NM_CLI;

but it does not work.

[Dave C-J]

that looks like an array of two objects, each of which is also and array...]so you would need one more [0] in there...

msg.payload = msg.payload[0][0].NM_CLI

[Nilton Cezar]

Great Dave, it was just like that!

Thank you very much!