Expected ':' and instead saw '+' in function node

General
1

I am using a function node to query MYSQL.
How ever, the function node says:

Expected ':' and instead saw '+



msg.topic = {
"INSERT or REPLACE INTO RANDOMNUM VALUES ( " + msg.payload[0].mmsi + "," + msg.payload[0].channel + ", " + msg.payload[0].messageType + ","+ msg.payload[0].repeatIndicator +"," + msg.payload[0].navigationStatus+","+msg.payload[0].sog+","+ msg.payload[0].positionAccurate+","+msg.payload[0].lon+", "+msg.payload[0].lat+","+msg.payload[0].timeStamp+","+msg.payload[0].raim+","+msg.payload[0].radioStatus+","+msg.payload[0].talkerId+","+msg.payload[0].sentenceId+","+msg.payload[0].talkerId_text+","+msg.payload[0].sentenceId_text+","+msg.payload[0].messageType_text+","+msg.payload[0].navigationStatus_text+","+msg.payload[0].bearing+","+msg.payload[0].distanceKM+","+ msg.payload[0].distanceNM+","+msg.payload[0].version+","+msg.payload[0].shipId+","+payload[0].callsign+","+msg.payload[0].name+","+msg.payload[0].shipType+","+msg.payload[0].dimensionToBow+","+msg.payload[0].dimensionToStern+","+msg.payload[0].dimensionToPort+","+msg.payload[0].dimensionToStarboard+","+msg.payload[0].fixType+","+msg.payload[0].eta+","+msg.payload[0].draught+","+msg.payload[0].destination+","+msg.payload[0].dte+","+msg.payload[0].shipType_text+","+msg.payload[0].fixType_text+","+msg.payload[0].turningDirection+","+msg.payload[0].cog+","+msg.payload[0].trueHeading+","+msg.payload[0].turningDirection_text+","+msg.payload[0].originalMessage+")"}
return msg;


[{"id":"571c45aaf00fb3c8","type":"function","z":"54c5117e.d70ef","name":"","func":"\n\nmsg.topic = {\n\"INSERT or REPLACE INTO RANDOMNUM VALUES ( \" + msg.payload[0].mmsi + \",\" + msg.payload[0].channel + \", \" + msg.payload[0].messageType + \",\"+ msg.payload[0].repeatIndicator +\",\" + msg.payload[0].navigationStatus+\",\"+msg.payload[0].sog+\",\"+ msg.payload[0].positionAccurate+\",\"+msg.payload[0].lon+\", \"+msg.payload[0].lat+\",\"+msg.payload[0].timeStamp+\",\"+msg.payload[0].raim+\",\"+msg.payload[0].radioStatus+\",\"+msg.payload[0].talkerId+\",\"+msg.payload[0].sentenceId+\",\"+msg.payload[0].talkerId_text+\",\"+msg.payload[0].sentenceId_text+\",\"+msg.payload[0].messageType_text+\",\"+msg.payload[0].navigationStatus_text+\",\"+msg.payload[0].bearing+\",\"+msg.payload[0].distanceKM+\",\"+ msg.payload[0].distanceNM+\",\"+msg.payload[0].version+\",\"+msg.payload[0].shipId+\",\"+payload[0].callsign+\",\"+msg.payload[0].name+\",\"+msg.payload[0].shipType+\",\"+msg.payload[0].dimensionToBow+\",\"+msg.payload[0].dimensionToStern+\",\"+msg.payload[0].dimensionToPort+\",\"+msg.payload[0].dimensionToStarboard+\",\"+msg.payload[0].fixType+\",\"+msg.payload[0].eta+\",\"+msg.payload[0].draught+\",\"+msg.payload[0].destination+\",\"+msg.payload[0].dte+\",\"+msg.payload[0].shipType_text+\",\"+msg.payload[0].fixType_text+\",\"+msg.payload[0].turningDirection+\",\"+msg.payload[0].cog+\",\"+msg.payload[0].trueHeading+\",\"+msg.payload[0].turningDirection_text+\",\"+msg.payload[0].originalMessage+\")\"}\nreturn msg;\n","outputs":1,"noerr":1,"initialize":"","finalize":"","libs":[],"x":1900,"y":1020,"wires":[["68f4b37f6039a3f4","0ae4250a30b335c7"]]}]

Where am I suppose to put the ':' then?

2

Get rid of the { } you have surrounding the string.

1 Like
3

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.