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

**URL:** <https://discourse.nodered.org/t/how-to-insert-data-with-this-string-value-and-how-to-split-it-i-new-for-using-node-red/50248>\
**Category:** General\
**Created:** [27 August 2021 05:42 UTC](https://discourse.nodered.org/t/how-to-insert-data-with-this-string-value-and-how-to-split-it-i-new-for-using-node-red/50248 "2021-08-27T05:42:47Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![erdowaka](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/erdowaka/32/47053_2.png) [@erdowaka](https://discourse.nodered.org/u/erdowaka)\
**Post date:** [27 August 2021 05:42 UTC](https://discourse.nodered.org/t/how-to-insert-data-with-this-string-value-and-how-to-split-it-i-new-for-using-node-red/50248/1 "2021-08-27T05:42:47Z")

</div>

![error](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/1/9/19b36ee09983f7e42d56c568273ac5352db27ab2.png)

help me for this problem

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [27 August 2021 06:20 UTC](https://discourse.nodered.org/t/how-to-insert-data-with-this-string-value-and-how-to-split-it-i-new-for-using-node-red/50248/2 "2021-08-27T06:20:06Z")

</div>

Welcome to the forum.

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

---

<div class="post-metadata">

**Author:** ![erdowaka](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/erdowaka/32/47053_2.png) [@erdowaka](https://discourse.nodered.org/u/erdowaka)\
**Post date:** [1 September 2021 08:52 UTC](https://discourse.nodered.org/t/how-to-insert-data-with-this-string-value-and-how-to-split-it-i-new-for-using-node-red/50248/3 "2021-09-01T08:52:43Z")

</div>

Thanks for answer mr.collin, i try like this

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/8/7/874b65c882bc66b2d190f07f05052d4711ff02ff.png)  
but i still get error

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [1 September 2021 09:10 UTC](https://discourse.nodered.org/t/how-to-insert-data-with-this-string-value-and-how-to-split-it-i-new-for-using-node-red/50248/4 "2021-09-01T09:10:27Z")

</div>

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](https://discourse.nodered.org/t/how-to-share-code-or-flow-json/506)

---

<div class="post-metadata">

**Author:** ![erdowaka](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/erdowaka/32/47053_2.png) [@erdowaka](https://discourse.nodered.org/u/erdowaka)\
**Post date:** [1 September 2021 09:14 UTC](https://discourse.nodered.org/t/how-to-insert-data-with-this-string-value-and-how-to-split-it-i-new-for-using-node-red/50248/5 "2021-09-01T09:14:54Z")

</div>

```auto
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 :  
 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/7/f/7fdfd539d781281c39844437d9ae38b62b5caac7.png)

---

<div class="post-metadata">

**Author:** ![Colin](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/colin/32/17040_2.png) [@Colin](https://discourse.nodered.org/u/Colin)\
**Post date:** [1 September 2021 09:38 UTC](https://discourse.nodered.org/t/how-to-insert-data-with-this-string-value-and-how-to-split-it-i-new-for-using-node-red/50248/6 "2021-09-01T09:38:43Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Steve-Mcl](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/steve-mcl/32/4826_2.png) [@Steve-Mcl](https://discourse.nodered.org/u/Steve-Mcl)\
**Post date:** [1 September 2021 10:41 UTC](https://discourse.nodered.org/t/how-to-insert-data-with-this-string-value-and-how-to-split-it-i-new-for-using-node-red/50248/7 "2021-09-01T10:41:40Z")

</div>

![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/b/5/b5e5d7c1cdaa2d8e7e7b266a387968ea4ab13bd7.png)

---

<div class="post-metadata">

**Author:** ![erdowaka](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/erdowaka/32/47053_2.png) [@erdowaka](https://discourse.nodered.org/u/erdowaka)\
**Post date:** [1 September 2021 10:43 UTC](https://discourse.nodered.org/t/how-to-insert-data-with-this-string-value-and-how-to-split-it-i-new-for-using-node-red/50248/8 "2021-09-01T10:43:50Z")

</div>

> [@Colin](#):
>
> mariadb docs

ok thanks, it solved just missing ' '

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [31 October 2021 10:44 UTC](https://discourse.nodered.org/t/how-to-insert-data-with-this-string-value-and-how-to-split-it-i-new-for-using-node-red/50248/9 "2021-10-31T10:44:03Z")

</div>

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.