# 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:** 1\
**Showing post:** 3

<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.

---

_[View the full topic](https://forum.inductiveautomation.com/t/conversion-error-query-returned-null-binding-needs-double/14756)._