# MySQL Query Works in Browser but not in Script

**URL:** <https://forum.inductiveautomation.com/t/mysql-query-works-in-browser-but-not-in-script/53968>\
**Category:** Ignition\
**Tags:** ignition80, database, scripting\
**Created:** [December 9, 2021, 8:32pm UTC](https://forum.inductiveautomation.com/t/mysql-query-works-in-browser-but-not-in-script/53968 "2021-12-09T20:32:12Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![amarks](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/amarks/32/45610_2.png) [@amarks](https://forum.inductiveautomation.com/u/amarks)\
**Post date:** [December 9, 2021, 8:32pm UTC](https://forum.inductiveautomation.com/t/mysql-query-works-in-browser-but-not-in-script/53968/1 "2021-12-09T20:32:13Z")

</div>

Why would my named query fail to run in a script if it works in the query browser?

I have a named query with one parameter. When I copy/paste the query into the query browser and replace the parameter with a number it runs and returns the results I expect. However, when I use the system.db.runNamedQuery() method in the script console I get a “You have an error in your SQL syntax” error message.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [December 9, 2021, 8:33pm UTC](https://forum.inductiveautomation.com/t/mysql-query-works-in-browser-but-not-in-script/53968/2 "2021-12-09T20:33:51Z")

</div>

We aren’t mind readers. Show us.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [December 9, 2021, 8:38pm UTC](https://forum.inductiveautomation.com/t/mysql-query-works-in-browser-but-not-in-script/53968/4 "2021-12-09T20:38:52Z")

</div>

Show us the authoring tab of your named query, too.

---

<div class="post-metadata">

**Author:** ![amarks](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/amarks/32/45610_2.png) [@amarks](https://forum.inductiveautomation.com/u/amarks)\
**Post date:** [December 9, 2021, 8:40pm UTC](https://forum.inductiveautomation.com/t/mysql-query-works-in-browser-but-not-in-script/53968/6 "2021-12-09T20:40:20Z")

</div>

And there it is…

The extra colon. Parameters are “:parameter” not “:parameter:”

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [December 9, 2021, 8:40pm UTC](https://forum.inductiveautomation.com/t/mysql-query-works-in-browser-but-not-in-script/53968/7 "2021-12-09T20:40:54Z")

</div>

👍

---

<div class="post-metadata">

**Author:** ![bkarabinchak.psi](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bkarabinchak.psi/32/83567_2.png) [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\
**Post date:** [December 9, 2021, 8:49pm UTC](https://forum.inductiveautomation.com/t/mysql-query-works-in-browser-but-not-in-script/53968/8 "2021-12-09T20:49:47Z")

</div>

The socratic method does it again!

---

<div class="post-metadata">

**Author:** ![Matrix\_Engineering](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/matrix_engineering/32/19781_2.png) [@Matrix\_Engineering](https://forum.inductiveautomation.com/u/Matrix_Engineering)\
**Post date:** [December 9, 2021, 11:56pm UTC](https://forum.inductiveautomation.com/t/mysql-query-works-in-browser-but-not-in-script/53968/9 "2021-12-09T23:56:38Z")

</div>

Psst! As soon as you saw gold users, you should have advised that no help can be offered on the forum for Integrator tests.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [December 10, 2021, 2:05am UTC](https://forum.inductiveautomation.com/t/mysql-query-works-in-browser-but-not-in-script/53968/10 "2021-12-10T02:05:53Z")

</div>

Shoot! Missed that.

---

<div class="post-metadata">

**Author:** ![amarks](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/amarks/32/45610_2.png) [@amarks](https://forum.inductiveautomation.com/u/amarks)\
**Post date:** [December 10, 2021, 1:59pm UTC](https://forum.inductiveautomation.com/t/mysql-query-works-in-browser-but-not-in-script/53968/11 "2021-12-10T13:59:59Z")

</div>

I only asked because I thought I had found a bug.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [December 10, 2021, 2:03pm UTC](https://forum.inductiveautomation.com/t/mysql-query-works-in-browser-but-not-in-script/53968/12 "2021-12-10T14:03:50Z")

</div>

You are only allowed to ask the IA testing group. The forum is _ **forbidden** _ for anything related to certification.