MySQL Query Works in Browser but not in Script

Ignition
, ,
1

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.

2

We aren’t mind readers. Show us.

2 Likes
4

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

6

And there it is…

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

2 Likes
7

:+1:

8

The socratic method does it again!

6 Likes
9

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

1 Like
10

Shoot! Missed that.

11

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

12

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

1 Like