How to pass a null value received on msg.req.query to msg.payload

Question

I am developing an application using Dashdb on Bluemix and nodered, my PHP application uses the call to webservice to invoke the node-red, whenever my function on PHP invokes the node to insert on table and the field GEO_ID is null, the application fails, I understand the issue, it seems the third parameter was not informed, I have just tried to check the param before and passing something like NULL but it continues not working.

See the code:

msg.account_id = msg.req.query.account_id;
msg.user_id = msg.req.query.user_id;
msg.geo_id=msg.req.query.geo_id;
msg.payload = "INSERT INTO ACCOUNT_USER (ACCOUNT_ID, USER_ID, GEO_ID) VALUES (?,?,?) ";
return msg;

And on Dashdb component I have set the parameter as below:

msg.account_id,msg.user_id,msg.geo_id

The third geo_id is the issue, I have tried something like the code below:

if(msg.req.query.geo_id===null){msg.geo_id=null}

or

if(msg.req.query.geo_id===null){msg.geo_id="null"}

The error I got is the one below:

dashDB query node: Error: [IBM][CLI Driver][DB2/LINUXX8664] SQL0420N Invalid character found in a character string argument of the function "DECIMAL". SQLSTATE=22018

I really appreciate if someone could help me on it . Thanks, Eduardo Diogo Garcia

What happens if you leave the `msg.geo_id` undefined? – hardillb Jul 04 '16 at 10:10 — hardillb, Jul 04 '16 at 10:10

score 1 · Answer 1 · answered Jul 04 '16 at 22:22

Is it possible that msg.req.query.geo_id is set to an empty string?

In that case neither if statement above would get executed, and you would be trying to insert an empty string into a DECIMAL column. Maybe try something like this:

if (! msg.req.query.geo_id || msg.req.query.geo_id == '') {
   msg.geo_id = null;
}

How to pass a null value received on msg.req.query to msg.payload

1 Answers1