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	423	9 October 2022
Update More than one Value with SQLITE General	2	797	3 November 2018
Sir ,I want to copy 2 msg.id in my sql DB General	108	1382	6 October 2020
Update entry or create it to MariaDB (SQL Database) General	5	816	21 August 2021
Copying my Door control status back to my Mysql databse General	96	1359	4 August 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