Postgres globalMap query help

[Anonymous]

I am trying to update two columns based on globalMap (which gets the jobs ID).

This is my query that I have in query editor:

UPDATE jobs
SET succ_flag = 'success',
	last_exec_complete = current_timestamp
WHERE job_id ='" + ((String)globalMap.get("myJob")) +"'

But that gives me this error:

ERROR: invalid input syntax for integer: "" + ((String)globalMap.get("myJob")) +""
Position: 94

How am I supposed to add globalMap to my query?

[Anonymous]

int4

[TRF · Accepted solution]

Strange...
I suggest you to construct the query into a global variable and to display it before the tDBRow component

[Anonymous]

Yep, that helped me see the issue. It basically just showed me that in this case I didn't even have to use the global variable. Thanks.

[TRF]

Great!
Thanks to mark your case as solved.