# Node-red-contrib-mssql-plus =\> value in database is empty

**URL:** <https://discourse.nodered.org/t/node-red-contrib-mssql-plus-value-in-database-is-empty/52205>\
**Category:** General\
**Tags:** database\
**Created:** [14 October 2021 09:53 UTC](https://discourse.nodered.org/t/node-red-contrib-mssql-plus-value-in-database-is-empty/52205 "2021-10-14T09:53:30Z")\
**Posts on this page:** 1\
**Showing post:** 4

<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:** [14 October 2021 11:20 UTC](https://discourse.nodered.org/t/node-red-contrib-mssql-plus-value-in-database-is-empty/52205/4 "2021-10-14T11:20:36Z")

</div>

Hi, so a couple of things first.

1. Please post code between backticks  
`````  
`like this`  
`````

2. When copying values from the debug sidebar, use the "Copy Value" button that appears under your mouse cursor when you hover over the message  
 ![BX00Cy7yHi](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/b/d/bd1f333a9e043b061b39917c328b0094d3e52d30.gif)

* * *

On you your issue...

The debug BEFORE SQL shows payload is an `array` but in your SQL, you try to access `payload.ts_pos_wo_id` - an array is accessed by `[]` square brackets.

To simplify things (and avoid mistakes) use the "Copy Path" button that appears under your mouse cursor when you hover over the item of interest & use that.

* * *

Lastly,

I **strongly** recommend you use the parameters instead of {{{mustache}}} - this will protect your database against SQL injection.

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

---

_[View the full topic](https://discourse.nodered.org/t/node-red-contrib-mssql-plus-value-in-database-is-empty/52205)._