Fossil SCM
Fix SQL to find name for /json/timeline/event
Commit
2488996f64d78d5fa7120d0125733909c3a6ea10483beff411ef56f0352dbb40
Parent
6f0929ce000718c…
1 file changed
+1
-1
+1
-1
| --- src/json_timeline.c | ||
| +++ src/json_timeline.c | ||
| @@ -553,11 +553,11 @@ | ||
| 553 | 553 | #endif |
| 554 | 554 | db_multi_exec("%s", blob_buffer(&sql) /*safe-for-%s*/); |
| 555 | 555 | blob_reset(&sql); |
| 556 | 556 | db_prepare(&q, "SELECT" |
| 557 | 557 | // uuid is not useful for events |
| 558 | - " substr((SELECT tagname FROM tag AS tn WHERE tn.tagid=tagId AND tagname LIKE 'event-%%'),7) AS name," | |
| 558 | + " substr((SELECT tagname FROM tag AS tn WHERE tn.tagid=json_timeline.tagId AND tagname LIKE 'event-%%'),7) AS name," | |
| 559 | 559 | " mtime AS timestamp," |
| 560 | 560 | #if 0 |
| 561 | 561 | " timestampString AS timestampString," |
| 562 | 562 | #endif |
| 563 | 563 | " comment AS comment, " |
| 564 | 564 |
| --- src/json_timeline.c | |
| +++ src/json_timeline.c | |
| @@ -553,11 +553,11 @@ | |
| 553 | #endif |
| 554 | db_multi_exec("%s", blob_buffer(&sql) /*safe-for-%s*/); |
| 555 | blob_reset(&sql); |
| 556 | db_prepare(&q, "SELECT" |
| 557 | // uuid is not useful for events |
| 558 | " substr((SELECT tagname FROM tag AS tn WHERE tn.tagid=tagId AND tagname LIKE 'event-%%'),7) AS name," |
| 559 | " mtime AS timestamp," |
| 560 | #if 0 |
| 561 | " timestampString AS timestampString," |
| 562 | #endif |
| 563 | " comment AS comment, " |
| 564 |
| --- src/json_timeline.c | |
| +++ src/json_timeline.c | |
| @@ -553,11 +553,11 @@ | |
| 553 | #endif |
| 554 | db_multi_exec("%s", blob_buffer(&sql) /*safe-for-%s*/); |
| 555 | blob_reset(&sql); |
| 556 | db_prepare(&q, "SELECT" |
| 557 | // uuid is not useful for events |
| 558 | " substr((SELECT tagname FROM tag AS tn WHERE tn.tagid=json_timeline.tagId AND tagname LIKE 'event-%%'),7) AS name," |
| 559 | " mtime AS timestamp," |
| 560 | #if 0 |
| 561 | " timestampString AS timestampString," |
| 562 | #endif |
| 563 | " comment AS comment, " |
| 564 |