From 39ac4e92a547e4c3908ec4ed84b37099dd7163d3 Mon Sep 17 00:00:00 2001 From: Olaf Wintermann Date: Wed, 7 May 2025 21:12:38 +0200 Subject: [PATCH] fix fieldlist in SQL_NOTEBOOK_GET_NOTES query --- application/store.c | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/application/store.c b/application/store.c index 9f20da8..8d9b392 100644 --- a/application/store.c +++ b/application/store.c @@ -56,7 +56,7 @@ "select * from cols\n" \ "order by path;" -#define SQL_NOTEBOOK_GET_NOTES "select n.*, NULL as [__resources__resource_id], r.resource_id, r.parent_id, r.nodename, r.displayname, r.lastmodified, r.creationdate, r.iscollection, r.contenttype from resources r inner join notes n on r.resource_id = n.resource_id where parent_id = ? ;" +#define SQL_NOTEBOOK_GET_NOTES "select n.*, r.resource_id as [__resources__resource_id], r.parent_id, r.nodename, r.displayname, r.lastmodified, r.creationdate, r.iscollection, r.contenttype from resources r inner join notes n on r.resource_id = n.resource_id where parent_id = ? ;" #define SQL_NOTE_GET_CONTENT "select content from resources where resource_id = ? ;" -- 2.43.5