# Indirect binding to SQL tag row?

**URL:** <https://forum.inductiveautomation.com/t/indirect-binding-to-sql-tag-row/31498>\
**Category:** Ignition\
**Created:** [January 21, 2020, 11:40pm UTC](https://forum.inductiveautomation.com/t/indirect-binding-to-sql-tag-row/31498 "2020-01-21T23:40:54Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![waldner](https://avatars.discourse-cdn.com/v4/letter/w/a5b964/32.png) [@waldner](https://forum.inductiveautomation.com/u/waldner)\
**Post date:** [January 21, 2020, 11:40pm UTC](https://forum.inductiveautomation.com/t/indirect-binding-to-sql-tag-row/31498/1 "2020-01-21T23:40:54Z")

</div>

I have an SQL tag that returns a 5-lines, 10-columns dataset. One of the columns is “name”. Now I want to bind a text box to column “name” of a parametrized row, so I thought I could set a binding to `[default]mytag.value[name][{1}]` where {1} is the parametrized line number. However, I don’t seem to get any value. Am I doing something wrong?

---

<div class="post-metadata">

**Author:** ![Kurt.Larson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/kurt.larson/32/6426_2.png) [@Kurt.Larson](https://forum.inductiveautomation.com/u/Kurt.Larson)\
**Post date:** [January 22, 2020, 3:54am UTC](https://forum.inductiveautomation.com/t/indirect-binding-to-sql-tag-row/31498/2 "2020-01-22T03:54:51Z")

</div>

You’ll have to use a tag reference within an expression binding instead. {[default]myTag}[{Root Container.rowIndex}, “name”] within an expression binding will return the cell’s value for the row index (custom prop) and “name” col.

---

<div class="post-metadata">

**Author:** ![waldner](https://avatars.discourse-cdn.com/v4/letter/w/a5b964/32.png) [@waldner](https://forum.inductiveautomation.com/u/waldner)\
**Post date:** [January 22, 2020, 10:51am UTC](https://forum.inductiveautomation.com/t/indirect-binding-to-sql-tag-row/31498/3 "2020-01-22T10:51:29Z")

</div>

Works, thanks. However, this has to be entered by hand, since using the guided tag/property selector in both the indirect tag binding and the expression binding leads to an expression of the form `[default]mytag.value[name][{Root Container.rowIndex}]`