# Testing NamedQuery works fine, but system.db.runNamedQuery inserts NULL in all columns

**URL:** <https://forum.inductiveautomation.com/t/testing-namedquery-works-fine-but-system-db-runnamedquery-inserts-null-in-all-columns/56154>\
**Category:** Ignition\
**Tags:** ignition81, database, scripting\
**Created:** [February 15, 2022, 10:08am UTC](https://forum.inductiveautomation.com/t/testing-namedquery-works-fine-but-system-db-runnamedquery-inserts-null-in-all-columns/56154 "2022-02-15T10:08:32Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Fred\_Ravandi](https://avatars.discourse-cdn.com/v4/letter/f/a88e57/32.png) [@Fred\_Ravandi](https://forum.inductiveautomation.com/u/Fred_Ravandi)\
**Post date:** [February 15, 2022, 10:08am UTC](https://forum.inductiveautomation.com/t/testing-namedquery-works-fine-but-system-db-runnamedquery-inserts-null-in-all-columns/56154/1 "2022-02-15T10:08:32Z")

</div>

I have a NamedQuery type=Update Query with couple of parameters. it works fine in Testing environment, but when I run system.db.runNamedQuery in client, I can see a row to database added with all NULL parameters.  
I am using MySQL. The Query is:

INSERT INTO tasks  
(Col1 , Col2 , Col3 , Col3 )  
VALUES  
(:V1, :V2, :V3, :V4)

Any idea What am I missing?

Script:  
params = {“Col1”:“Test1”, “Col2”:“Test2”, “Col3”:1, “Col4”:2}  
system.db.runNamedQuery(“MyNamedQuery”, params )

---

<div class="post-metadata">

**Author:** ![lrose](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/lrose/32/62724_2.png) [@lrose](https://forum.inductiveautomation.com/u/lrose)\
**Post date:** [February 15, 2022, 12:43pm UTC](https://forum.inductiveautomation.com/t/testing-namedquery-works-fine-but-system-db-runnamedquery-inserts-null-in-all-columns/56154/2 "2022-02-15T12:43:13Z")

</div>

The Keys in your params dictionary must match what you have named them in the named query, not the column names.

```auto
params = {'V1': 'Test1', 'V2': 'Test2', 'V3': 1,'V4':2}
system.db.runNamedQuery('MyNamedQuery',params)

```

---

<div class="post-metadata">

**Author:** ![Fred\_Ravandi](https://avatars.discourse-cdn.com/v4/letter/f/a88e57/32.png) [@Fred\_Ravandi](https://forum.inductiveautomation.com/u/Fred_Ravandi)\
**Post date:** [February 16, 2022, 5:36am UTC](https://forum.inductiveautomation.com/t/testing-namedquery-works-fine-but-system-db-runnamedquery-inserts-null-in-all-columns/56154/3 "2022-02-16T05:36:20Z")

</div>

Thanks Irose, All good now.  
What a silly mistake.