Changeset 6339


Ignore:
Timestamp:
May 24, 2010, 10:12:35 PM (10 years ago)
Author:
nikrou
Message:

Fix bug 1695 : incorrect boolean to string conversion for SQLite and PostgreSQL database engines

Location:
trunk/include/dblayer
Files:
3 edited

Legend:

Unmodified
Added
Removed
  • trunk/include/dblayer/functions_pdo-sqlite.inc.php

    r6153 r6339  
    468468function boolean_to_string($var)
    469469{
    470   if (!empty($var) && ($var == 'true'))
    471   {
    472     return 'true';
     470  if (is_bool($var))
     471  {
     472    return $var ? 'true' : 'false';
    473473  }
    474474  else
    475475  {
    476     return 'false';
     476    return $var;
    477477  }
    478478}
  • trunk/include/dblayer/functions_pgsql.inc.php

    r6090 r6339  
    511511function boolean_to_string($var)
    512512{
    513   if (!empty($var) && ($var == 't'))
    514   {
    515     return 'true';
     513  if (is_bool($var))
     514  {
     515    return $var ? 'true' : 'false';
    516516  }
    517517  else
    518518  {
    519     return 'false';
     519    return $var;
    520520  }
    521521}
  • trunk/include/dblayer/functions_sqlite.inc.php

    r6153 r6339  
    480480function boolean_to_string($var)
    481481{
    482   if (!empty($var) && ($var == 'true'))
    483   {
    484     return 'true';
     482  if (is_bool($var))
     483  {
     484    return $var ? 'true' : 'false';
    485485  }
    486486  else
    487487  {
    488     return 'false';
     488    return $var;
    489489  }
    490490}
Note: See TracChangeset for help on using the changeset viewer.