# Error: ER\_TRUNCATED\_WRONG\_VALUE

**URL:** <https://discourse.nodered.org/t/error-er-truncated-wrong-value/36639>\
**Category:** General\
**Created:** [27 November 2020 18:07 UTC](https://discourse.nodered.org/t/error-er-truncated-wrong-value/36639 "2020-11-27T18:07:57Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rhum1x56](https://avatars.discourse-cdn.com/v4/letter/r/bbe5ce/32.png) [@Rhum1x56](https://discourse.nodered.org/u/Rhum1x56)\
**Post date:** [27 November 2020 18:07 UTC](https://discourse.nodered.org/t/error-er-truncated-wrong-value/36639/1 "2020-11-27T18:07:57Z")

</div>

Hello, I need help with a school project.  
I am using an HTML POST to send data to nodered. But after some processing, I have BDD errors

My function :

msg.tps = msg.payload; [//msg.tps=time](https://msg.tps=time) seconde (structure BDD type float)  
msg.num\_prod =msg.payload.Num\_prod; //num\_prod=2 (structure BDD type int and test text)

msg.topic = "UPDATE production set duree = '"+ msg.tps +"' WHERE num\_prod='"+ msg.num\_prod +"';"  
return [msg];

when i replace num\_prod='"+ msg.num\_prod +"' BY num\_prod='2' It's ok

Error is : erreur Error: ER\_TRUNCATED\_WRONG\_VALUE: Truncated incorrect DOUBLE value: undefined

thanks for your help  
sorry for my english i'm french

---

<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:** [27 November 2020 21:19 UTC](https://discourse.nodered.org/t/error-er-truncated-wrong-value/36639/2 "2020-11-27T21:19:24Z")

</div>

Welcome to the forum.

Add a Debug node showing what is coming out of your function node and see what it shows.

---

<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:** [26 January 2021 21:19 UTC](https://discourse.nodered.org/t/error-er-truncated-wrong-value/36639/3 "2021-01-26T21:19:30Z")

</div>

Closed on 26 January 2021 21:19 UTC

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