# Read values from S7 component to mysql query

**URL:** <https://discourse.nodered.org/t/read-values-from-s7-component-to-mysql-query/17048>\
**Category:** General\
**Created:** [23 October 2019 10:39 UTC](https://discourse.nodered.org/t/read-values-from-s7-component-to-mysql-query/17048 "2019-10-23T10:39:08Z")\
**Posts on this page:** 1\
**Showing post:** 8

<div class="post-metadata">

**Author:** ![bakman2](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/bakman2/32/6207_2.png) [@bakman2](https://discourse.nodered.org/u/bakman2)\
**Post date:** [23 October 2019 13:50 UTC](https://discourse.nodered.org/t/read-values-from-s7-component-to-mysql-query/17048/8 "2019-10-23T13:50:36Z")

</div>

Please export your flow again, [read this post](https://discourse.nodered.org/t/how-to-share-code-or-flow-json/506) and edit your post.

First determine the debug output of your node.

This line:  
`msg.topic = "INSERT into Temps(Temp1) VALUES ('str1')"; //`

`str1` inserted as a string, not the data/object/array that you are looking for.

It should be something like

`VALUES ('"+str1+"')"`

---

_[View the full topic](https://discourse.nodered.org/t/read-values-from-s7-component-to-mysql-query/17048)._