[Koha-cvs] CVS: koha/admin thesaurus.pl,1.9,1.9.2.1

[MJ Ray]

Update of /cvsroot/koha/koha/admin
In directory sc8-pr-cvs1:/tmp/cvs-serv4454/admin

Modified Files:
      Tag: rel_2_0
        thesaurus.pl 
Log Message:
DBI call fix for bug 662

Index: thesaurus.pl
===================================================================
RCS file: /cvsroot/koha/koha/admin/thesaurus.pl,v
retrieving revision 1.9
retrieving revision 1.9.2.1
diff -C2 -r1.9 -r1.9.2.1
*** thesaurus.pl        10 Jul 2003 14:11:46 -0000      1.9
--- thesaurus.pl        19 Dec 2003 02:15:25 -0000      1.9.2.1
***************
*** 39,43 ****
  my $father=$input->param('father');
  
! my $reqsel="select category,stdlib,freelib from bibliothesaurus where 
id='$id'";
  my $reqdel="delete from bibliothesaurus where id='$id'";
  my $script_name="/cgi-bin/koha/admin/thesaurus.pl";
--- 39,43 ----
  my $father=$input->param('father');
  
! my $reqsel="";
  my $reqdel="delete from bibliothesaurus where id='$id'";
  my $script_name="/cgi-bin/koha/admin/thesaurus.pl";
***************
*** 74,79 ****
        if ($id) {
                my $dbh = C4::Context->dbh;
!               my $sth=$dbh->prepare("select id,category,freelib,stdlib from 
bibliothesaurus where id='$id'");
!               $sth->execute;
                $data=$sth->fetchrow_hashref;
                $sth->finish;
--- 74,79 ----
        if ($id) {
                my $dbh = C4::Context->dbh;
!               my $sth=$dbh->prepare("select id,category,freelib,stdlib from 
bibliothesaurus where id=?");
!               $sth->execute($id);
                $data=$sth->fetchrow_hashref;
                $sth->finish;
***************
*** 124,129 ****
  } elsif ($op eq 'delete_confirm') {
        my $dbh = C4::Context->dbh;
!       my $sth=$dbh->prepare($reqsel);
!       $sth->execute;
        my $data=$sth->fetchrow_hashref;
        $sth->finish;
--- 124,129 ----
  } elsif ($op eq 'delete_confirm') {
        my $dbh = C4::Context->dbh;
!       my $sth=$dbh->prepare("select category,stdlib,freelib from 
bibliothesaurus where id=?");
!       $sth->execute($id);
        my $data=$sth->fetchrow_hashref;
        $sth->finish;