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…

zenofmud 16 October 2019 01:24 6

The database schema - the create table's syntax to show what al the columns are

Topic		Replies	Views
SQLite SELECT from node-red function return nothing but in DB browser works fine General database , function-node	11	1100	16 February 2022
Sqlite SELECT OK from terminal, empty result from NR General database	14	265	20 December 2022
Select data from SQlite not working General	2	358	27 March 2022
Help with Sqlite Select clause General	5	576	5 January 2020
Error after selecting data from SQLITE General	5	899	9 July 2018

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.

Sqlite select query not returning data

Related topics