aboutsummaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
authorTristan Riehs <tristan.riehs@inria.fr>2025-11-14 20:19:16 +0100
committerTristan Riehs <tristan.riehs@inria.fr>2025-11-14 20:19:16 +0100
commit9a36e20e16757df824dfb8cca9284c45d3a2b52e (patch)
tree11e6b11dc788dd49c4aa94d83258e5e2ed866a96 /src
parente8378d575dd77cf1436ee147920b7c775ee3b7af (diff)
Query was not working because tag ID was bad
Diffstat (limited to 'src')
-rw-r--r--src/main.c3
1 files changed, 2 insertions, 1 deletions
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);
}