[Koha-cvs] CVS: koha/C4 Catalogue.pm,1.27,1.28

[Paul POULAIN]

Update of /cvsroot/koha/koha/C4
In directory sc8-pr-cvs1:/tmp/cvs-serv5002/C4

Modified Files:
        Catalogue.pm 
Log Message:
fixing a sql query not using prepare(?) & execute($var) method

Index: Catalogue.pm
===================================================================
RCS file: /cvsroot/koha/koha/C4/Catalogue.pm,v
retrieving revision 1.27
retrieving revision 1.28
diff -C2 -r1.27 -r1.28
*** Catalogue.pm        16 Oct 2002 12:44:25 -0000      1.27
--- Catalogue.pm        28 Jan 2003 14:53:30 -0000      1.28
***************
*** 335,343 ****
    $sth->execute;
    $sth->finish;
!   $query="update aqorderbreakdown set bookfundid=$bookfund where
!   ordernumber=$ordnum";
    $sth=$dbh->prepare($query);
  #  print $query;
!   $sth->execute;
    $sth->finish;
  }
--- 335,343 ----
    $sth->execute;
    $sth->finish;
!   $query="update aqorderbreakdown set bookfundid=? where
!   ordernumber=?";
    $sth=$dbh->prepare($query);
  #  print $query;
!   $sth->execute($bookfund,$ordnum);
    $sth->finish;
  }