Hi. Anyone knows here is it possible if we can update sql table where the query with an id has 2 strings. The result I got is only A2 string is taken as identifier thus row contains id A1 is not updated. [image]

[image] Kimo: WHERE [Name] = '"+Name+"'" that is not what I said to do... [image] Steve-Mcl: WHERE [name] IN ('A1','A2') e.g.. const array = flow.get('array'); //example ["A1", "A2"]; if(!array || !array.length) { node.warn("array is empty"); return null // halt flow } const…

Steve-Mcl 19 August 2022 07:56 2

This looks like a double posting - how is this different from your previous post?

Topic		Replies	Views
Update SQL Table of multiple rows with different identifiers Share Your Projects	4	436	9 October 2022
Update More than one Value with SQLITE General	2	821	3 November 2018
Node Red Update SQL General	18	3997	5 May 2020
MySQL statement help General	8	487	5 January 2020
Insert array contents into MSSQL table General	24	3996	27 July 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.

How to update SQL query with an identifier has 2 strings

Related topics