# Ignition Named Query getting error

**URL:** <https://forum.inductiveautomation.com/t/ignition-named-query-getting-error/106691>\
**Category:** Ignition\
**Tags:** namedqueries\
**Created:** [May 26, 2025, 2:17pm UTC](https://forum.inductiveautomation.com/t/ignition-named-query-getting-error/106691 "2025-05-26T14:17:05Z")\
**Posts on this page:** 1\
**Showing post:** 3

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [May 26, 2025, 2:53pm UTC](https://forum.inductiveautomation.com/t/ignition-named-query-getting-error/106691/3 "2025-05-26T14:53:29Z")

</div>

Line 97 of your error log states,

> Caused by: com.microsoft.sqlserver.jdbc.SQLServerException:  
> Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.

However, even if you fix this you might still be in trouble. The JDBC driver does not support SQL scripting. See [Are comments in Named Queries known to not work correctly? - #11 by pturmel](https://forum.inductiveautomation.com/t/are-comments-in-named-queries-known-to-not-work-correctly/79319/11), etc., for more. (There are other posts on the forum. Try searching for "JDBC".)

---

_[View the full topic](https://forum.inductiveautomation.com/t/ignition-named-query-getting-error/106691)._