From 9a36e20e16757df824dfb8cca9284c45d3a2b52e Mon Sep 17 00:00:00 2001 From: Tristan Riehs Date: Fri, 14 Nov 2025 20:19:16 +0100 Subject: Query was not working because tag ID was bad --- src/main.c | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/src/main.c b/src/main.c index 955e990..6abe608 100644 --- a/src/main.c +++ b/src/main.c @@ -408,10 +408,11 @@ static void ftag_query_join(sqlite3 *db, char *sql, int max_len, strncat(sql, prefix, max_len - strlen(sql)); assert(strlen(sql) <= max_len); ftag_query_join(db, sql, max_len, tags, tag_count-1); + int tag_id = get_id_by_col(db, "tags", "name", tags[tag_count-1]); char suffix[128]; memset(suffix, 0, sizeof(suffix)); snprintf(suffix, sizeof(suffix)-1, - "\t\tON id = file\n\t\tWHERE tag = %d)\n", tag_count-1); + "\t\tON id = file\n\t\tWHERE tag = %d)\n", tag_id); strncat(sql, suffix, max_len - strlen(sql)); assert(strlen(sql) <= max_len); } -- cgit v1.2.3