# SQL query tag - tag path malformed

**URL:** <https://forum.inductiveautomation.com/t/sql-query-tag-tag-path-malformed/11853>\
**Category:** Ignition\
**Created:** [June 23, 2016, 4:35pm UTC](https://forum.inductiveautomation.com/t/sql-query-tag-tag-path-malformed/11853 "2016-06-23T16:35:50Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![jackswiggett](https://avatars.discourse-cdn.com/v4/letter/j/57b2e6/32.png) [@jackswiggett](https://forum.inductiveautomation.com/u/jackswiggett)\
**Post date:** [June 23, 2016, 4:35pm UTC](https://forum.inductiveautomation.com/t/sql-query-tag-tag-path-malformed/11853/1 "2016-06-23T16:35:50Z")

</div>

I have created a query tag called "P001\_settings" inside a folder called "Processes". It is connected to a MySQL data table with the query "SELECT \* from test.P001\_settings" (which is working as expected).

I am trying to bind the value of a text field in the designer to one of the values in the tag. In particular, I want to select the value at column 0, row 0. Column 0 is called 'property'. If I use Ignition's browsing interface to bind to that value, it generates the tag path "Processes/P001\_settings[property][0, 0]". When I click OK I get the following error indicating that the tag path is malformed. Is this tag path incorrect, and what is the correct tag path format to select values from a query tag?

> [@](#):
>
> java.io.IOException: com.google.common.collect.ComputationException: com.inductiveautomation.ignition.common.sqltags.parser.TagPathFormatException: Illegal character '[' (Line 1 , Char 24)

I'm using:  
Ignition v7.8.2 (b2016030813)  
Java: Oracle Corporation 1.8.0\_91

Thanks,  
Jack

---

<div class="post-metadata">

**Author:** ![jcharrison](https://avatars.discourse-cdn.com/v4/letter/j/c0e974/32.png) [@jcharrison](https://forum.inductiveautomation.com/u/jcharrison)\
**Post date:** [June 28, 2016, 2:42pm UTC](https://forum.inductiveautomation.com/t/sql-query-tag-tag-path-malformed/11853/2 "2016-06-28T14:42:12Z")

</div>

You should try and use the lookup expression. It is very useful in retrieving particular row,column values from both dataset tags and query tags.
