[Phpcompta-dev] r4401 - phpcompta/trunk/include

[phpcompta-dev]

Author: danydb
Date: 2011-11-18 14:44:37 +0100 (Fri, 18 Nov 2011)
New Revision: 4401

Modified:
   phpcompta/trunk/include/ajax_auto_anc_card.php
Log:
0000462: Autocompletion probl operateur ~*

Modified: phpcompta/trunk/include/ajax_auto_anc_card.php
===================================================================
--- phpcompta/trunk/include/ajax_auto_anc_card.php      2011-11-18 13:42:55 UTC 
(rev 4400)
+++ phpcompta/trunk/include/ajax_auto_anc_card.php      2011-11-18 13:44:37 UTC 
(rev 4401)
@@ -7,12 +7,12 @@
 $user->check_dossier($_GET['gDossier']);
 if ( isset($_REQUEST['pa_id']) )
 {   
-    $res=$cn->exec_sql("select po_id,po_description from  poste_analytique 
where pa_id=$1 ~* and (po_description ~*$2 or po_id ~* $3 order by po_id limit 
12",
+    $res=$cn->exec_sql("select po_id,po_description from  poste_analytique 
where pa_id=$1 ~* and (po_description ~* $2 or po_id ~* $3 order by po_id limit 
12",
         array($_REQUEST['pa_id'],$_POST['anccard'],$_POST['anccard']));
 }
 else
 {
-       $res=$cn->exec_sql("select po_id,po_description from  poste_analytique 
where po_description ~*$1 or po_id ~* $2 order by po_id limit 12 ",
+       $res=$cn->exec_sql("select po_id,po_description from  poste_analytique 
where po_description ~* $1 or po_id ~* $2 order by po_id limit 12 ",
         array($_POST['anccard'],$_POST['anccard']));
 }
 $nb=Database::num_row($res);