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

**URL:** <https://discourse.nodered.org/t/expected-and-instead-saw-in-function-node/54571>\
**Category:** General\
**Created:** [1 December 2021 13:02 UTC](https://discourse.nodered.org/t/expected-and-instead-saw-in-function-node/54571 "2021-12-01T13:02:39Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Nice\_to\_have](https://avatars.discourse-cdn.com/v4/letter/n/edb3f5/32.png) [@Nice\_to\_have](https://discourse.nodered.org/u/Nice_to_have)\
**Post date:** [1 December 2021 13:02 UTC](https://discourse.nodered.org/t/expected-and-instead-saw-in-function-node/54571/1 "2021-12-01T13:02:39Z")

</div>

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

Expected ':' and instead saw '+

```auto

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;

```

```auto
[{"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?

---

<div class="post-metadata">

**Author:** ![knolleary](https://sea2.discourse-cdn.com/flex026/user_avatar/discourse.nodered.org/knolleary/32/3_2.png) [@knolleary](https://discourse.nodered.org/u/knolleary)\
**Post date:** [1 December 2021 13:08 UTC](https://discourse.nodered.org/t/expected-and-instead-saw-in-function-node/54571/2 "2021-12-01T13:08:43Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/1X/d073cd938eafa2e558d7c2cd59003b3ef4963033.png) [@system](https://discourse.nodered.org/u/system)\
**Post date:** [15 December 2021 13:09 UTC](https://discourse.nodered.org/t/expected-and-instead-saw-in-function-node/54571/3 "2021-12-15T13:09:17Z")

</div>

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