# Null record logged in MSSQL when using parser payload value to logged

**URL:** <https://discourse.nodered.org/t/null-record-logged-in-mssql-when-using-parser-payload-value-to-logged/32900>\
**Category:** General\
**Created:** [15 September 2020 04:39 UTC](https://discourse.nodered.org/t/null-record-logged-in-mssql-when-using-parser-payload-value-to-logged/32900 "2020-09-15T04:39:08Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ajay1](https://avatars.discourse-cdn.com/v4/letter/a/a3d4f5/32.png) [@Ajay1](https://discourse.nodered.org/u/Ajay1)\
**Post date:** [15 September 2020 04:39 UTC](https://discourse.nodered.org/t/null-record-logged-in-mssql-when-using-parser-payload-value-to-logged/32900/1 "2020-09-15T04:39:08Z")

</div>

parser-  
msg.payload = ["[swapmicro","swapmicro@gmail.com](mailto:swapmicro%22,%22swapmicro@gmail.com)","swap","zzz@321",55.66];  
return msg;

DECLARE @data VARCHAR(MAX)  
DECLARE @Name VARCHAR(50)  
DECLARE @Email VARCHAR(50)  
DECLARE @usName VARCHAR(50)  
DECLARE @PWD VARCHAR(50)  
DECLARE @NUB FLOAT  
SET @Name = '{{{msg.payload[0]}}}';  
SET @Email = '{{{msg.payload[1]}}}';  
SET @usName = '{{{msg.payload[2]}}}';  
SET @PWD = '{{{msg.payload[3]}}}';  
SET @NUB = '{{{msg.payload[4]}}}';  
INSERT INTO dbo.Test  
( name, email, usName, pwd,nub )  
VALUES ( @Name,  
@Email,  
@usName,  
@PWD,  
''  
)  
then null record logged in table .

 ![Capture](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/4/e/4ed5310c2b7733851238a0d0b84c313813f5e225.png)

---

<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:** [15 September 2020 07:11 UTC](https://discourse.nodered.org/t/null-record-logged-in-mssql-when-using-parser-payload-value-to-logged/32900/2 "2020-09-15T07:11:43Z")

</div>

> [@Ajay1](#):
>
> INSERT INTO dbo.Test  
> ( name, email, usName, pwd,nub )  
> VALUES ( @Name,  
> @Email,  
> @usName,  
> @PWD,  
> ''  
> )

Best guess - `data` is null because you dont specify the column or a value for the `data` field in your INSERT statement.

---

<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:** [14 November 2020 07:11 UTC](https://discourse.nodered.org/t/null-record-logged-in-mssql-when-using-parser-payload-value-to-logged/32900/3 "2020-11-14T07:11:45Z")

</div>

Closed on 14 November 2020 07:11 UTC

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