diff options
Diffstat (limited to 'src')
| -rw-r--r-- | src/db_handler.py | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/src/db_handler.py b/src/db_handler.py index c0dba76..dc3540f 100644 --- a/src/db_handler.py +++ b/src/db_handler.py @@ -17,7 +17,7 @@ class DBHandler: cur = con.cursor() cur.execute( ''' - SELECT id, nickname, comment, page_url, visitor_url, (CASE WHEN show_contact THEN contact ELSE NULL END) as contact, created_at + SELECT id, nickname, comment, page_url, visitor_url, (CASE WHEN show_contact THEN contact ELSE NULL END) as contact_info, created_at FROM comment WHERE approved AND public AND page_url = ? ORDER BY created_at DESC; ''', (url,)) comments = cur.fetchall() |