# Passing different datatypes tp a named query

**URL:** <https://forum.inductiveautomation.com/t/passing-different-datatypes-tp-a-named-query/40067>\
**Category:** Ignition\
**Created:** [October 27, 2020, 8:10pm UTC](https://forum.inductiveautomation.com/t/passing-different-datatypes-tp-a-named-query/40067 "2020-10-27T20:10:54Z")\
**Posts on this page:** 1\
**Showing post:** 22

<div class="post-metadata">

**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\
**Post date:** [October 28, 2020, 5:56pm UTC](https://forum.inductiveautomation.com/t/passing-different-datatypes-tp-a-named-query/40067/22 "2020-10-28T17:56:45Z")

</div>

And if you want to do both the table name and the column name then you could do something like this:

```auto
tableName ="binder_names"
columnName = "binder_name"
query = "UPDATE {0} SET {1}=? WHERE id=?".format(tableName,columnName)
system.db.runPrepUpdate(query=query, args=args)

```

---

_[View the full topic](https://forum.inductiveautomation.com/t/passing-different-datatypes-tp-a-named-query/40067)._