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	426	9 October 2022
mySQL, update 2 cells General	2	81	26 December 2023
SQLite update problem General	3	179	14 October 2022
Update More than one Value with SQLITE General	2	809	3 November 2018
Updating multiple SQL records at once General	6	334	4 February 2023

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