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

Ignition
1

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
image1141×799 87.1 KB

2

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.

1 Like
3

Thanks for your help. That fixed it