Need explicit cast

diff --git a/src/InfoCon/stempel/index.wml b/src/InfoCon/stempel/index.wml
index 79c098b..c4af1ed 100644 (file)
--- a/src/InfoCon/stempel/index.wml
+++ b/src/InfoCon/stempel/index.wml
@@ -33,7 +33,7 @@
 
   $query = "SELECT oid,start,customer,time,task FROM stempel WHERE time IS NOT NULL ";
   if (isset($month) && $month !== 'all')
-    $query .= "AND start LIKE '".$month."-%' ";
+    $query .= "AND cast(start AS TEXT) LIKE '".$month."-%' ";
   $query .= "ORDER BY customer,start";
 
   $sth = pg_exec ($dbh, $query);

diff --git a/src/InfoCon/stempel/status.wml b/src/InfoCon/stempel/status.wml
index 1fcec70..85d10b6 100644 (file)
--- a/src/InfoCon/stempel/status.wml
+++ b/src/InfoCon/stempel/status.wml
@@ -50,7 +50,7 @@ echo '<br'.$query;
 
     $query = "SELECT oid,start,customer,time,task FROM stempel WHERE time IS NOT NULL ";
     if (isset($month) && $month !== 'all')
-      $query .= "AND start LIKE '".$month."-%' ";
+      $query .= "AND cast(start AS TEXT) LIKE '".$month."-%' ";
     if (isset($status)) {
       if ($status != 'all')
         $query .= "AND status = $status ";

diff --git a/src/InfoCon/stempel/submenu.inc b/src/InfoCon/stempel/submenu.inc
index 0f3a470..f3711da 100644 (file)
--- a/src/InfoCon/stempel/submenu.inc
+++ b/src/InfoCon/stempel/submenu.inc
@@ -6,7 +6,7 @@
     global $dbh;
 
     $a = array();
-    $query = "SELECT DISTINCT substr(start,0,8) FROM stempel ORDER BY substr(start,0,8)";
+    $query = "SELECT DISTINCT substr(cast(start AS TEXT),0,8) FROM stempel ORDER BY substr(cast(start AS TEXT),0,8)";
     $sth = pg_exec ($dbh, $query);
 
     while ($row = pg_fetch_array ($sth)) {