Passing column name as a variable to a named query

[twstevic]

This is the named query:
INSERT INTO a_stats.dock_door_induct_counts ({param1}) VALUES (:param2);

[JordanCClark]

What happens if you drag the parameter into your query?

[nminchin]

@twstevic

system.db.runNamedQuery(A_Stats, “dockDoorUpdate”, params)

It doesnt look like A_Stats is defined anywhere. If this is the name of your project, then it should be within apostrophes or quotes

[JordanCClark]

Wait. The problem is at the logger. Try:

logger.info (str(params['param1']))

Or better yet, to see the entire dictionary:

logger.info (str(params))

For future reference, the traceback tells you what line the script fails at.

Traceback (most recent call last): File “”, line 19, in NameError: name ‘param1’ is not defined

[twstevic]

Ah Ha!!! ‘A_Stats’ worked. It is a wonderful day in the neighborhood.

Thank you all!!