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 19 October 2019 22:43 12

I think that since you are sending the sql via the msg.topic, it ends processing at the ; at the end of the create index statement. So you can only send in one statenment at a time.

If you use the batch option, No result rows are returned.

Topic		Replies	Views
SQLite SELECT from node-red function return nothing but in DB browser works fine General database , function-node	11	1059	16 February 2022
Sqlite SELECT OK from terminal, empty result from NR General database	14	235	20 December 2022
Inconsistent SQLite node query behaviour General database , sqlite	11	78	26 November 2024
Node-red returns empty when sending query to Microsoft SQL Server General database	5	218	1 February 2023
Help with a Select Query Function General	13	1573	12 March 2020

Sqlite select query not returning data

Related topics