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	192	12 December 2022
Insert new record into MSSQL General	5	280	18 March 2023
How to insert an array into mssql? General	23	4836	16 August 2019
SQLite insert problem General	9	562	22 August 2019
Howto SQL-Query with quotes General	23	1830	31 March 2021

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