# Binding a dropdown to a column in a database where the results are text

**URL:** <https://forum.inductiveautomation.com/t/binding-a-dropdown-to-a-column-in-a-database-where-the-results-are-text/101551>\
**Category:** Ignition\
**Tags:** ignition81\
**Created:** [January 29, 2025, 2:54pm UTC](https://forum.inductiveautomation.com/t/binding-a-dropdown-to-a-column-in-a-database-where-the-results-are-text/101551 "2025-01-29T14:54:34Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Charles\_Bair](https://avatars.discourse-cdn.com/v4/letter/c/74df32/32.png) [@Charles\_Bair](https://forum.inductiveautomation.com/u/Charles_Bair)\
**Post date:** [January 29, 2025, 2:54pm UTC](https://forum.inductiveautomation.com/t/binding-a-dropdown-to-a-column-in-a-database-where-the-results-are-text/101551/1 "2025-01-29T14:54:34Z")

</div>

I keep getting the error in the picture below when I try to bind a dropdown to a query that is referencing a column in a database. I have tried several different query scripting but get the same alarm with each one. Any help would be greatly appreciated.

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

---

<div class="post-metadata">

**Author:** ![YF129701](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/yf129701/32/60498_2.png) [@YF129701](https://forum.inductiveautomation.com/u/YF129701)\
**Post date:** [January 29, 2025, 3:22pm UTC](https://forum.inductiveautomation.com/t/binding-a-dropdown-to-a-column-in-a-database-where-the-results-are-text/101551/2 "2025-01-29T15:22:36Z")

</div>

Remove your QueryString parameter (in the Named Query definition) - it's not being used and I don't see where you would use it in your query as you don't have a `WHERE` clause.

---

<div class="post-metadata">

**Author:** ![Charles\_Bair](https://avatars.discourse-cdn.com/v4/letter/c/74df32/32.png) [@Charles\_Bair](https://forum.inductiveautomation.com/u/Charles_Bair)\
**Post date:** [January 29, 2025, 4:12pm UTC](https://forum.inductiveautomation.com/t/binding-a-dropdown-to-a-column-in-a-database-where-the-results-are-text/101551/3 "2025-01-29T16:12:12Z")

</div>

Thanks for your help. That fixed it