# RequestError: Incorrect syntax near '.'

**URL:** <https://discourse.nodered.org/t/requesterror-incorrect-syntax-near/59605>\
**Category:** General\
**Created:** [9 March 2022 16:24 UTC](https://discourse.nodered.org/t/requesterror-incorrect-syntax-near/59605 "2022-03-09T16:24:55Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![QGIO](https://avatars.discourse-cdn.com/v4/letter/q/f17d59/32.png) [@QGIO](https://discourse.nodered.org/u/QGIO)\
**Post date:** [9 March 2022 16:24 UTC](https://discourse.nodered.org/t/requesterror-incorrect-syntax-near/59605/1 "2022-03-09T16:24:55Z")

</div>

I have created the following flow:  
\</\>

 ![immagine](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/b/5/b5659692b5018c8903acf1347c3cdb18e4f11a6c.png)

in which I send by the button 'Carica' a number to the function in order to select a specific raw of a SQL database table.  
On the MSSQL node I get the following error:  
RequestError: Incorrect syntax near '.'

Could you help me to found the problem?

---

<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:** [9 March 2022 16:26 UTC](https://discourse.nodered.org/t/requesterror-incorrect-syntax-near/59605/2 "2022-03-09T16:26:00Z")

</div>

The best way for us to help you is if you add a Debug node to the output of the Function node so we can all see _exactly_ what SQL you are sending to the MSSQL node. That's the only way we can help you spot what syntax error you have.

---

<div class="post-metadata">

**Author:** ![QGIO](https://avatars.discourse-cdn.com/v4/letter/q/f17d59/32.png) [@QGIO](https://discourse.nodered.org/u/QGIO)\
**Post date:** [9 March 2022 16:30 UTC](https://discourse.nodered.org/t/requesterror-incorrect-syntax-near/59605/3 "2022-03-09T16:30:44Z")

</div>

![immagine](https://us1.discourse-cdn.com/flex026/uploads/nodered/original/3X/1/b/1b6c588fba810583ac66951c8e08d6547b8e52bb.png)

---

<div class="post-metadata">

**Author:** ![QGIO](https://avatars.discourse-cdn.com/v4/letter/q/f17d59/32.png) [@QGIO](https://discourse.nodered.org/u/QGIO)\
**Post date:** [9 March 2022 16:33 UTC](https://discourse.nodered.org/t/requesterror-incorrect-syntax-near/59605/4 "2022-03-09T16:33:10Z")

</div>

I think I forgot FROM

---

<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:** [8 May 2022 16:34 UTC](https://discourse.nodered.org/t/requesterror-incorrect-syntax-near/59605/5 "2022-05-08T16:34:02Z")

</div>

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