Differences From:

File src/tkt.c part of check-in [86db6fa150] - Split of the ticket configuratio into separately editable pieces. by drh on 2008-05-28 15:29:16. [view]

To:

File src/tkt.c part of check-in [49380d500a] - Continuing work on the ticketing system. by drh on 2008-05-28 18:48:12. [view]

@@ -103,10 +103,11 @@
   const char *zName;
   Stmt q;
   int i, n, size, j;
 
-  zName = PD("name","");
-  db_prepare(&q, "SELECT * FROM ticket WHERE tkt_uuid GLOB '%q*'", zName);
+  zName = PD("name","-none-");
+  db_prepare(&q, "SELECT datetime(tkt_mtime) AS tkt_datetime, *"
+                 "  FROM ticket WHERE tkt_uuid GLOB '%q*'", zName);
   if( db_step(&q)==SQLITE_ROW ){
     n = db_column_count(&q);
     for(i=0; i<n; i++){
       const char *zVal = db_column_text(&q, i);