# Conversion error: query returned null, binding needs "double"

**URL:** <https://forum.inductiveautomation.com/t/conversion-error-query-returned-null-binding-needs-double/14756>\
**Category:** Ignition\
**Created:** [July 11, 2017, 3:57pm UTC](https://forum.inductiveautomation.com/t/conversion-error-query-returned-null-binding-needs-double/14756 "2017-07-11T15:57:45Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Slurpee](https://avatars.discourse-cdn.com/v4/letter/s/4da419/32.png) [@Slurpee](https://forum.inductiveautomation.com/u/Slurpee)\
**Post date:** [July 11, 2017, 3:57pm UTC](https://forum.inductiveautomation.com/t/conversion-error-query-returned-null-binding-needs-double/14756/1 "2017-07-11T15:57:45Z")

</div>

Hi all need a little help here.  
I am using a Numeric Text field to display values but  
I always get this error if the result is null, even I have tick the Fall back Value and set to 0

Exception: Conversion error: query returned null, binding needs “double”  
on query binding for “StdUnit\_Chart.Root Container.Container Chart.Container.Numeric Text Field 2.doubleValue”

This is my query:  
SELECT  
Sum(Scrap)  
FROM Ignition\_database  
where Machine = ‘10’ and [Date] = ‘2017-07-10’

Does somebody has a work around for this or is there something that I am missing?

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [July 11, 2017, 4:46pm UTC](https://forum.inductiveautomation.com/t/conversion-error-query-returned-null-binding-needs-double/14756/2 "2017-07-11T16:46:32Z")

</div>

Try this:

```auto
SELECT 
COALESCE(Sum(Scrap), 0)
FROM Ignition_database
where Machine = '10' and [Date] = '2017-07-10'

```

---

<div class="post-metadata">

**Author:** ![Sanderd17](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/sanderd17/32/8735_2.png) [@Sanderd17](https://forum.inductiveautomation.com/u/Sanderd17)\
**Post date:** [July 11, 2017, 6:33pm UTC](https://forum.inductiveautomation.com/t/conversion-error-query-returned-null-binding-needs-double/14756/3 "2017-07-11T18:33:36Z")

</div>

@Slurpee, fallback is useful in case no values are returned (zero rows). While in your case, the SUM function always returns exactly 1 value; Null in case there is no data in your selection.

Also see this thread from a few days ago: [SQL Query error handler?](http://forum.inductiveautomation.com/t/sql-query-error-handler/14623)  
Similar situation, but with the MAX function instead of SUM.

---

<div class="post-metadata">

**Author:** ![Slurpee](https://avatars.discourse-cdn.com/v4/letter/s/4da419/32.png) [@Slurpee](https://forum.inductiveautomation.com/u/Slurpee)\
**Post date:** [July 11, 2017, 7:10pm UTC](https://forum.inductiveautomation.com/t/conversion-error-query-returned-null-binding-needs-double/14756/4 "2017-07-11T19:10:47Z")

</div>

thanks a lot @paul-griffith it works perfect…