Node Red - insert

Share Your Projects
,
1

Hi! I would need help on this matter. How do I differentiate the Var, so it does not take the same values ​​as shown in the attachment.

msg.fecha=new Date();
var fecha   =  msg.payload
var Tension1 = msg.payload
var Tension2 = msg.payload
var Tension3 = msg.payload
msg.topic = "INSERT INTO sepam(fecha,Tension1,Tension2,Tension3) VALUES (+'"+fecha+"',+  '"+Tension1+"',+'"+Tension2+"', +'"+Tension3+"')";
return msg;

WhatsApp Image 2022-09-07 at 08.51.49
WhatsApp Image 2022-09-07 at 08.51.49899×1599 360 KB

2

Welcome to the forum @dantekempfen

You have set all three to the value of msg.payload, so they will all be the same. Are you sending multiple messages to the node and need to combine the data from those messages? If so then you can use a Join node for that. See this article in the cookbook for an example of how to join messages into one object.

If the values are not coming from multiple messages then you need to give us more information.

3

HI, @Colin!!! Yes, I need the VARs to be different so that it shows me three different messages. How can I do?

4

how are you getting the variables into your flow ? Source ?

5

Did you look at the example link I posted?