# Named Queries binding with SQL Table Name

**URL:** <https://forum.inductiveautomation.com/t/named-queries-binding-with-sql-table-name/75919>\
**Category:** Ignition\
**Tags:** ignition81, vision, perspective, database\
**Created:** [July 5, 2023, 3:18am UTC](https://forum.inductiveautomation.com/t/named-queries-binding-with-sql-table-name/75919 "2023-07-05T03:18:20Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![arsalan.junaid](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/arsalan.junaid/32/48885_2.png) [@arsalan.junaid](https://forum.inductiveautomation.com/u/arsalan.junaid)\
**Post date:** [July 5, 2023, 3:18am UTC](https://forum.inductiveautomation.com/t/named-queries-binding-with-sql-table-name/75919/1 "2023-07-05T03:18:20Z")

</div>

Hi,

I am trying to link a variable (String) to the Table on a NamedQuery in Perspective Ignition 8.1.19 but it is not working.

My code:

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/5/45ecfbc962dc7302377ebe58f9c4807958f509b3.png)

Error:

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/c/d/cd36d000a6a1efe10279c6ebc68b057a23da4b89.png)

Previously the following worked in Vision:

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/8/5/850520d1e68c3a10527749c44b43832bb4e4ab32.png)

Could anyone please guide.  
Thanks

---

<div class="post-metadata">

**Author:** ![pascal.fragnoud](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pascal.fragnoud/32/24728_2.png) [@pascal.fragnoud](https://forum.inductiveautomation.com/u/pascal.fragnoud)\
**Post date:** [July 5, 2023, 7:30am UTC](https://forum.inductiveautomation.com/t/named-queries-binding-with-sql-table-name/75919/2 "2023-07-05T07:30:24Z")

</div>

You'll need to use a query string instead of a value variable for this.

---

<div class="post-metadata">

**Author:** ![arsalan.junaid](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/arsalan.junaid/32/48885_2.png) [@arsalan.junaid](https://forum.inductiveautomation.com/u/arsalan.junaid)\
**Post date:** [July 5, 2023, 7:45am UTC](https://forum.inductiveautomation.com/t/named-queries-binding-with-sql-table-name/75919/3 "2023-07-05T07:45:13Z")

</div>

Thanks @pascal.fragnoud. That was so simple. 🤯

---

<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:** [July 5, 2023, 12:09pm UTC](https://forum.inductiveautomation.com/t/named-queries-binding-with-sql-table-name/75919/4 "2023-07-05T12:09:54Z")

</div>

Be very careful, though. QueryString parameters are not secure, so you must not allow user-entered values in such parameters.

---

<div class="post-metadata">

**Author:** ![arsalan.junaid](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/arsalan.junaid/32/48885_2.png) [@arsalan.junaid](https://forum.inductiveautomation.com/u/arsalan.junaid)\
**Post date:** [July 5, 2023, 12:26pm UTC](https://forum.inductiveautomation.com/t/named-queries-binding-with-sql-table-name/75919/5 "2023-07-05T12:26:29Z")

</div>

Sure @pturmel I am using it for predefined variables only.  
Thanks for the warning btw. 👌