Author: danydb
Date: 2012-06-27 13:10:52 +0200 (Wed, 27 Jun 2012)
New Revision: 5017
Modified:
phpcompta/trunk/include/class_acc_account_ledger.php
Log:
Bug due to PSQL 9.0 data must be casted
Modified: phpcompta/trunk/include/class_acc_account_ledger.php
===================================================================
--- phpcompta/trunk/include/class_acc_account_ledger.php 2012-06-27
11:04:30 UTC (rev 5016)
+++ phpcompta/trunk/include/class_acc_account_ledger.php 2012-06-27
11:10:52 UTC (rev 5017)
@@ -563,18 +563,18 @@
if ( strstr($item_cred,"*") == true )
{
$item_cred=strtr($item_cred,"*","%");
- $SqlItem="$or pcm_val::text like '$item_cred'";
+ $SqlItem="$or pcm_val::text like
'".sql_string($item_cred)."'";
$or=" or ";
}
else
{
- $SqlItem="$or pcm_val::text = '$item_cred' ";
+ $SqlItem="$or pcm_val::text = '".sql_string($item_cred)."'
";
$or=" or ";
}
$SqlFilter=$SqlFilter.$SqlItem;
}
}//foreach
- $sql.=$SqlFilter.' and pcm_val::text='.$this->id;
+ $sql.=$SqlFilter." and pcm_val::text='".sql_string($this->id)."'";
$max=$this->db->get_value($sql);
if ($max > 0 )
return 0;
---
PhpCompta est un logiciel de comptabilité libre en ligne (full web)
Projet opensource http://www.phpcompta.eu
_______________________________________________
Phpcompta est un logiciel libre de comptabilité en ligne
(http://www.phpcompta.eu)
Phpcompta-dev mailing list
[email protected]
https://lists.nongnu.org/mailman/listinfo/phpcompta-dev
