# Running SQL update query in webdev module

**URL:** <https://forum.inductiveautomation.com/t/running-sql-update-query-in-webdev-module/56541>\
**Category:** Ignition\
**Created:** [February 25, 2022, 12:08am UTC](https://forum.inductiveautomation.com/t/running-sql-update-query-in-webdev-module/56541 "2022-02-25T00:08:23Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Prerak\_patel](https://avatars.discourse-cdn.com/v4/letter/p/e79b87/32.png) [@Prerak\_patel](https://forum.inductiveautomation.com/u/Prerak_patel)\
**Post date:** [February 25, 2022, 12:08am UTC](https://forum.inductiveautomation.com/t/running-sql-update-query-in-webdev-module/56541/1 "2022-02-25T00:08:23Z")

</div>

Hello, I am trying to run system.db.runUpdateQuery() in Webdev doPost module. But when I execute the code by sending data to URL, then it gives me following error.

**[## HTTP ERROR 500 java.lang.Exception: java.lang.Exception: Error executing system.db.runUpdateQuery()]**

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [February 25, 2022, 1:14am UTC](https://forum.inductiveautomation.com/t/running-sql-update-query-in-webdev-module/56541/2 "2022-02-25T01:14:00Z")

</div>

Check your gateway logs for the actual error.

---

<div class="post-metadata">

**Author:** ![jespinmartin1](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jespinmartin1/32/57175_2.png) [@jespinmartin1](https://forum.inductiveautomation.com/u/jespinmartin1)\
**Post date:** [February 25, 2022, 3:53am UTC](https://forum.inductiveautomation.com/t/running-sql-update-query-in-webdev-module/56541/3 "2022-02-25T03:53:08Z")

</div>

I bet you forgot the 3rd parameter haha, just maybe.

---

<div class="post-metadata">

**Author:** ![Prerak\_patel](https://avatars.discourse-cdn.com/v4/letter/p/e79b87/32.png) [@Prerak\_patel](https://forum.inductiveautomation.com/u/Prerak_patel)\
**Post date:** [March 1, 2022, 4:22pm UTC](https://forum.inductiveautomation.com/t/running-sql-update-query-in-webdev-module/56541/4 "2022-03-01T16:22:03Z")

</div>

Thank you. It was a syntax error in the query.
