# Table Query Binding returns Error\_Exception

**URL:** <https://forum.inductiveautomation.com/t/table-query-binding-returns-error-exception/110420>\
**Category:** Ignition\
**Created:** [September 5, 2025, 8:05pm UTC](https://forum.inductiveautomation.com/t/table-query-binding-returns-error-exception/110420 "2025-09-05T20:05:40Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Michael\_Perry](https://avatars.discourse-cdn.com/v4/letter/m/a6a055/32.png) [@Michael\_Perry](https://forum.inductiveautomation.com/u/Michael_Perry)\
**Post date:** [September 5, 2025, 8:05pm UTC](https://forum.inductiveautomation.com/t/table-query-binding-returns-error-exception/110420/1 "2025-09-05T20:05:40Z")

</div>

Issues with Table Data Queries

---

<div class="post-metadata">

**Author:** ![Michael\_Perry](https://avatars.discourse-cdn.com/v4/letter/m/a6a055/32.png) [@Michael\_Perry](https://forum.inductiveautomation.com/u/Michael_Perry)\
**Post date:** [September 5, 2025, 8:16pm UTC](https://forum.inductiveautomation.com/t/table-query-binding-returns-error-exception/110420/2 "2025-09-05T20:16:38Z")

</div>

The Query runs well under testing returning data as expected. When binding to the Table it returns the Error\_Exception stating “Error\_Exception-(“java.sql.SQLSyntaxErrorException: Unknown column' ‘Jammed’ in ‘where clause’”)

I’m sure I'm missing something. script provided in TXT

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/7/f7a76c2e872aed1ebd8cfe19a5d2b27e84a994f2.png)

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/b/fba2b626cb76eef49b398ccf76d6700e7e65b535.png)

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/3/0308017f3f8b09d309bebecbf93f88828afe5453.png)

[New Text Document.txt](https://forum.inductiveautomation.com/uploads/short-url/3a63MZL2rzqE83YqdYJvEgDuFd2.txt) (2.7 KB)

---

<div class="post-metadata">

**Author:** ![ryan.white](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ryan.white/32/73193_2.png) [@ryan.white](https://forum.inductiveautomation.com/u/ryan.white)\
**Post date:** [September 5, 2025, 8:21pm UTC](https://forum.inductiveautomation.com/t/table-query-binding-returns-error-exception/110420/3 "2025-09-05T20:21:01Z")

</div>

Post your SQL query as preformatted text, see [Wiki - how to post code on this forum](https://forum.inductiveautomation.com/t/wiki-how-to-post-code-on-this-forum/77831). You can edit your post by clicking the pencil Icon in the bottom right. (I would recommend editing the original post to include everything you put in the second post)

What flavor of DB are you using? How are you testing your query before binding it? Are you testing inside of ignition using the query browser are you using an external database management tool, such as SSMS?

---

<div class="post-metadata">

**Author:** ![ryan.white](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ryan.white/32/73193_2.png) [@ryan.white](https://forum.inductiveautomation.com/u/ryan.white)\
**Post date:** [September 5, 2025, 8:24pm UTC](https://forum.inductiveautomation.com/t/table-query-binding-returns-error-exception/110420/4 "2025-09-05T20:24:15Z")

</div>

Ah wait, you are using query strings with double quotes. Double quotes are used for identifiers in SQL, use single quotes. Any chance you are converting from MySQL to SQL server or PostgreSQL?

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [September 5, 2025, 8:24pm UTC](https://forum.inductiveautomation.com/t/table-query-binding-returns-error-exception/110420/5 "2025-09-05T20:24:24Z")

</div>

You are using QueryString parameters to pass values. Don't do that. (You are somehow getting double quotes into your actual param, which are identifier delimiters in SQL, not value delimiters.)

Don't try to do your own delimiting of strings. Pass values as values. QueryString params are for SQL **structure** variation, and should **never** carry user-entered values.