Passing different datatypes tp a named query

Ignition
22

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

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