I have a relatively big SQL SELECT query (44 lines). On the locally deployed sqlite database query works. On the server query works as well (server is the machine, where node-red runs + database file is deployed). From the node-red the query returns empty [ empty ] This is the flow I use: [{"id…

Sqlite select query not returning data

zenofmud 20 October 2019 00:59 14

Sure, send the first to the sql node then check the output to see it ran and if it did connect to another node to build the next sql statement and feel it to another SQLite node. Or you could put the SQLite node in a sub flow so you only have one instance of it.

Topic		Replies	Views
SQLite SELECT from node-red function return nothing but in DB browser works fine General database , function-node	11	980	16 February 2022
Sqlite SELECT OK from terminal, empty result from NR General database	14	192	20 December 2022
Node-red returns empty when sending query to Microsoft SQL Server General database	5	169	1 February 2023
Help with a Select Query Function General	13	1502	12 March 2020
Node-RED select sqlite db and transform the date into an object with arrays General	5	752	2 January 2022

Sqlite select query not returning data

Related Topics