# runPrepUpdate not updating?

**URL:** <https://forum.inductiveautomation.com/t/runprepupdate-not-updating/98921>\
**Category:** Ignition\
**Tags:** ignition81\
**Created:** [November 21, 2024, 9:52am UTC](https://forum.inductiveautomation.com/t/runprepupdate-not-updating/98921 "2024-11-21T09:52:49Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![Transistor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/transistor/32/3380_2.png) [@Transistor](https://forum.inductiveautomation.com/u/Transistor)\
**Post date:** [November 21, 2024, 10:13am UTC](https://forum.inductiveautomation.com/t/runprepupdate-not-updating/98921/2 "2024-11-21T10:13:37Z")

</div>

You're not dumb. It was discussed a few times on the forum. Here's one from eight years ago.

> [@Update with IN condition](https://forum.inductiveautomation.com/t/update-with-in-condition/11679/3):
>
> You cannot pass a list into a single ‘?’ substitution parameter. Jordan’s suggestion would be suitable in your case if you use ‘%s’ instead of ‘?’ and use the non-Prep form of the query. When using data types in a list that would be problematic when converted to a string, you must place one ‘?’ for each element of list. Like so:system.db.runPrepUpdate("UPDATE TEST SET FL= 1 WHERE ID IN (%s)" % (", ".join(['?'] \* len(y))), y, "dscada\_main")

---

_[View the full topic](https://forum.inductiveautomation.com/t/runprepupdate-not-updating/98921)._