Hello everyone, and thanks for reading and helping in advance. I have a flow that watches for excel files and inserts the data dynamically to an sql server database. My problem begins when some of the strings in the excel files have astrophes, and sometimes they dont. As mentioned, its dynamic. T…

Steve-Mcl 1 March 2022 13:22 6

If you are using the MSSQL-PLUS node, simply use parameters. No escaping necessary & will avoid SQL injection possibilities.

E.g... Dashboard and MS SQL database - number and text input nodes - #2 by Steve-Mcl

1 Like

Topic		Replies	Views
Syntax issues with SQL General	4	205	12 December 2022
Fine tune a "function" node General	17	1444	13 May 2020
Insert new record into MSSQL General	5	339	18 March 2023
How to insert an array into mssql? General	23	4995	16 August 2019
SQLite insert problem General	9	592	22 August 2019

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.

Inserting dynamic string with astrophes to SQL Server

Related Topics