# Does it matter?

**URL:** <https://discourse.nodered.org/t/does-it-matter/26398>\
**Category:** General\
**Created:** [10 May 2020 01:18 UTC](https://discourse.nodered.org/t/does-it-matter/26398 "2020-05-10T01:18:00Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![asdf123](https://avatars.discourse-cdn.com/v4/letter/a/838e76/32.png) [@asdf123](https://discourse.nodered.org/u/asdf123)\
**Post date:** [10 May 2020 01:18 UTC](https://discourse.nodered.org/t/does-it-matter/26398/1 "2020-05-10T01:18:00Z")

</div>

Hello,

I have a function, which results string array. I want to insert it into sqlite database line by line. Each line is the following value. Do I have to somehow convert the function message in order to insert it into the database?

---

<div class="post-metadata">

**Author:** ![krambriw](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/krambriw/32/5429_2.png) [@krambriw](https://discourse.nodered.org/u/krambriw)\
**Post date:** [10 May 2020 03:25 UTC](https://discourse.nodered.org/t/does-it-matter/26398/2 "2020-05-10T03:25:02Z")

</div>

Change the title to a more descriptive one. "Does it matter?"  
Yes it does

---

<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:** [10 May 2020 07:34 UTC](https://discourse.nodered.org/t/does-it-matter/26398/3 "2020-05-10T07:34:53Z")

</div>

Provide more information.

What is in the array of strings?

> [@asdf123](#):
>
> Each line is the following value.

What value?

> [@asdf123](#):
>
> Do I have to somehow convert the function message in order to insert it into the database?

That doesn't really make any sense. You have to generate SQL statements if that's what you mean. But again, you haven't explained what is in the strings.

This is the best I can offer...  
Send your array to a split node to create individual messages. If the string contains valid SQL, then feed that to the sqlite node (you might need a change node (between them) to move the SQL string to `msg.topic`)

Ps, please change the title to something relevant.

---

<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:** [10 May 2020 07:42 UTC](https://discourse.nodered.org/t/does-it-matter/26398/4 "2020-05-10T07:42:19Z")

</div>

Is this a continuation of your other thread?

If so, please stop creating multiple threads for the same issue. Stick to your original.

---

<div class="post-metadata">

**Author:** ![dceejay](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dceejay/32/38_2.png) [@dceejay](https://discourse.nodered.org/u/dceejay)\
**Post date:** [10 May 2020 08:47 UTC](https://discourse.nodered.org/t/does-it-matter/26398/5 "2020-05-10T08:47:00Z")

</div>

Closing this as the title makes no sense and the same discussion is in [Insert into SQlite database?](https://discourse.nodered.org/t/insert-into-sqlite-database/26390)

---

<div class="post-metadata">

**Author:** ![dceejay](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/dceejay/32/38_2.png) [@dceejay](https://discourse.nodered.org/u/dceejay)\
**Post date:** [10 May 2020 08:47 UTC](https://discourse.nodered.org/t/does-it-matter/26398/6 "2020-05-10T08:47:09Z")

</div>