How to insert data with this string value and how to split it, i new for using node-red

[erdowaka]

help me for this problem

[Colin]

Welcome to the forum.

Doesn't the payload need to be an array not a string? Check the help pane for the node.

[erdowaka]

Thanks for answer mr.collin, i try like this

but i still get error

[Colin]

It is very difficult for me to read that screenshot but it looks as if you have some quotes in the wrong place. When posting code in the future please paste it in using the method described in How to share code or flow json

[erdowaka]

var str = msg.payload;
var parts = str.split(" ");
x = parts[0];
y = parts[1];
percobaan_id = parts[2];
var hari = msg.myymd;
var jam = msg.mytimes;
var waktu = hari+" "+jam;
//var waktu = date.getTime();
msg.topic = "INSERT INTO eye_fixation(x,y,time,percobaan_id) VALUES("+x+", "+y+","+waktu+", "+ percobaan_id +")";
return msg;

and this my error :

[Colin]

Your SQL syntax is wrong, as the error says. You probably need quotes round the values or something. Check the mariadb docs as the error suggests.

[Steve-Mcl]

[erdowaka]

@Colin

mariadb docs

ok thanks, it solved just missing ' '