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
How to pass msg int value, to postgresql Dashboard database	5	481	2 June 2022
Using mysql node but no joy with insert query General	7	1716	29 August 2020
Need help - Syntax MSSQL Insert Statement from a msg.payload General	3	492	9 December 2019
MSSQL-Plus - Appending the Query output to incoming payload.msg General	3	337	23 October 2021
Using msg.payload in a SQL query General	7	7241	23 June 2020

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