comments fix contact never shown

1 files changed, 1 insertions, 1 deletions

diff --git a/src/blog_node5_net.py b/src/blog_node5_net.py
index cf5907e..b1d290b 100644
--- a/src/blog_node5_net.py
+++ b/src/blog_node5_net.py
@@ -40,7 +40,7 @@ def get_comments(url: str) -> list[dict]:
         with conn.cursor() as cur:
             cur.execute(
                 "SELECT id, comment, page_url, visitor_url, username, "
-                "(CASE WHEN show_contact THEN contact ELSE NULL END), public, created_at "
+                "(CASE WHEN show_contact THEN contact ELSE NULL END) as contact, created_at "
                 "FROM comment WHERE approved AND public AND page_url = %(url)s ORDER BY created_at DESC;", {'url': url})
             comments = cur.fetchall()
             return comments