# Reading data from S7-300 and want to log in MSSQL need function or query

**URL:** <https://discourse.nodered.org/t/reading-data-from-s7-300-and-want-to-log-in-mssql-need-function-or-query/32979>\
**Category:** General\
**Created:** [17 September 2020 04:49 UTC](https://discourse.nodered.org/t/reading-data-from-s7-300-and-want-to-log-in-mssql-need-function-or-query/32979 "2020-09-17T04:49:36Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![malickamranahmed](https://avatars.discourse-cdn.com/v4/letter/m/9fc348/32.png) [@malickamranahmed](https://discourse.nodered.org/u/malickamranahmed)\
**Post date:** [17 September 2020 04:49 UTC](https://discourse.nodered.org/t/reading-data-from-s7-300-and-want-to-log-in-mssql-need-function-or-query/32979/1 "2020-09-17T04:49:37Z")

</div>

Hi,

I am new to node red and trying to build a Dashboard as a hobbiest . For this i am reading data from Siemens PLC data block and i want to store that data in MSSQL and not able to write function for it .

 ![image](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/6/d/6d91bcc3675ef4aac646da226e1578960c9413c9.png)

above is the PLC tag DB124,Word0 as shown in picture

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

i have tried to make function but it is now successful at all .

Can any body here help me in writing a function that can export data to my Data base having table "nodered" with column "recipe name"

---

<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:** [17 September 2020 06:59 UTC](https://discourse.nodered.org/t/reading-data-from-s7-300-and-want-to-log-in-mssql-need-function-or-query/32979/2 "2020-09-17T06:59:08Z")

</div>

Can I ask why, as a hobbyist, you want to use mssql?  
Why do you want to store the data? There may well be better and simpler ways.

---

<div class="post-metadata">

**Author:** ![malickamranahmed](https://avatars.discourse-cdn.com/v4/letter/m/9fc348/32.png) [@malickamranahmed](https://discourse.nodered.org/u/malickamranahmed)\
**Post date:** [17 September 2020 07:07 UTC](https://discourse.nodered.org/t/reading-data-from-s7-300-and-want-to-log-in-mssql-need-function-or-query/32979/3 "2020-09-17T07:07:38Z")

</div>

I want to learn MSSQL Databases as well with this hobby project .

---

<div class="post-metadata">

**Author:** ![malickamranahmed](https://avatars.discourse-cdn.com/v4/letter/m/9fc348/32.png) [@malickamranahmed](https://discourse.nodered.org/u/malickamranahmed)\
**Post date:** [17 September 2020 07:48 UTC](https://discourse.nodered.org/t/reading-data-from-s7-300-and-want-to-log-in-mssql-need-function-or-query/32979/4 "2020-09-17T07:48:09Z")

</div>

i want to make a dashboard using Grafana for that i need to store data.

---

<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:** [17 September 2020 08:10 UTC](https://discourse.nodered.org/t/reading-data-from-s7-300-and-want-to-log-in-mssql-need-function-or-query/32979/5 "2020-09-17T08:10:32Z")

</div>

> [@malickamranahmed](#):
>
> Can any body here help me in writing a function that can export data to my Data base having table "nodered" with column "recipe name"

Hi Peter.

First things first ...  
Are you usung `mssql-plus` node?  
That node permits you to use any msg property to send the SQL statement. However, on most MSSQL nodes, you do NOT use `msg.topic`.

2ndly. Read the extensive built in help for the mssql-plus node. It has examples and info to get you going.

3rd, why not take advantage of mustache or better still parameters in the MSSQL node instead of building a string SQL statement in a function?

Lastly, on line 6 - that is not how you concatenate strings and variables. Perhaps you are new to JavaScript too? Try using `+` operator to concatenate or use a template string ``insert ..... Where field ='${variable}'``

---

<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:** [16 November 2020 08:10 UTC](https://discourse.nodered.org/t/reading-data-from-s7-300-and-want-to-log-in-mssql-need-function-or-query/32979/6 "2020-11-16T08:10:54Z")

</div>

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