# Result from Query database by script

**URL:** <https://forum.inductiveautomation.com/t/result-from-query-database-by-script/16128>\
**Category:** Ignition\
**Created:** [November 27, 2017, 6:37am UTC](https://forum.inductiveautomation.com/t/result-from-query-database-by-script/16128 "2017-11-27T06:37:11Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![win](https://avatars.discourse-cdn.com/v4/letter/w/65b543/32.png) [@win](https://forum.inductiveautomation.com/u/win)\
**Post date:** [November 27, 2017, 6:37am UTC](https://forum.inductiveautomation.com/t/result-from-query-database-by-script/16128/1 "2017-11-27T06:37:11Z")

</div>

i built some query database by script, then i use the selected result to calculate something.  
when there are some selected result, it is ok; but there is null(no data selected) result selected, ignition will show the error information. then how would i adjust the query result is null or not , is there some easy way?

Thanks in advanced!

---

<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:** [November 27, 2017, 5:03pm UTC](https://forum.inductiveautomation.com/t/result-from-query-database-by-script/16128/2 "2017-11-27T17:03:36Z")

</div>

[https://www.w3schools.com/sql/sql\_isnull.asp](https://www.w3schools.com/sql/sql_isnull.asp)