Hi node-red forum, Is it possible to pass a msg payload to SQL query node to use in the where cluase? I mean somenthing like this: [immagine] Which is the correct syntax? The path of the msg payload to pass is payload.topic1[0].ID

Sure, however you need to. e.g. ↓ When the value XXX comes from msg.payload[0].ID ↓ then... SELECT * FROM T1 where id=XXX becomes SELECT * FROM T1 where id=@ID and add a parameter for msg.payload[0].ID named ID

Steve-Mcl 23 March 2022 10:35 2

The "better" way is to use "Parameters"

Topic		Replies	Views
MSSQL-Plus - Appending the Query output to incoming payload.msg General	3	377	23 October 2021
How to access msg.payload array in mssql? General	10	2546	10 June 2020
Using msg.payload in a SQL query General	7	9178	23 June 2020
Using mysql node but no joy with insert query General	7	1852	29 August 2020
Payload to SQL query General database	3	548	6 December 2021

Copyright OpenJS Foundation and Node-RED contributors. All rights reserved. The OpenJS Foundation has registered trademarks and uses trademarks. For a list of trademarks of the OpenJS Foundation, please see our Trademark Policy and Trademark List. Trademarks and logos not indicated on the list of OpenJS Foundation trademarks are trademarks™ or registered® trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.

Pass msq payload to SQL query where clause

Related topics