[Fmsystem-commits] [12761] catch: caseinsensitive sql

[Sigurd Nes]

Revision: 12761
          http://svn.sv.gnu.org/viewvc/?view=rev&root=fmsystem&revision=12761
Author:   sigurdne
Date:     2015-02-18 18:22:42 +0000 (Wed, 18 Feb 2015)
Log Message:
-----------
catch: caseinsensitive sql

Modified Paths:
--------------
    trunk/catch/inc/custom/default/notify_by_email_18_1.php

Modified: trunk/catch/inc/custom/default/notify_by_email_18_1.php
===================================================================
--- trunk/catch/inc/custom/default/notify_by_email_18_1.php     2015-02-17 
23:05:20 UTC (rev 12760)
+++ trunk/catch/inc/custom/default/notify_by_email_18_1.php     2015-02-18 
18:22:42 UTC (rev 12761)
@@ -137,7 +137,7 @@
                $_utflyttingsdato        = 
$this->db->f('leie_opphore_fra_dato');
                if($_utflyttingsdato)
                {
-                       $this->db->query("SELECT id, num, utflyttingsdato FROM 
fm_catch_3_1 WHERE kontraktsnummer = '{$_kontraktsnummer}'", __LINE__, 
__FILE__);
+                       $this->db->query("SELECT id, num, utflyttingsdato FROM 
fm_catch_3_1 WHERE kontraktsnummer ilike '{$_kontraktsnummer}'", __LINE__, 
__FILE__);
                        if($this->db->next_record())
                        {
                                $_num_3_1                                = 
$this->db->f('num');
@@ -150,7 +150,7 @@
                        }
                        else
                        {
-                               $body .= "</br></br>Fant ikke inneflyttemelding 
for kontraktsnummer {$_kontraktsnummer}";
+                               $body .= "</br></br>Fant ikke innflyttemelding 
for kontraktsnummer {$_kontraktsnummer}";
                        }
                }
                else