koha-cvs
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[Koha-cvs] CVS: koha deletemem.pl,1.3,1.3.2.1


From: Andrew Arensburger
Subject: [Koha-cvs] CVS: koha deletemem.pl,1.3,1.3.2.1
Date: Thu, 03 Oct 2002 18:52:27 -0700

Update of /cvsroot/koha/koha
In directory usw-pr-cvs1:/tmp/cvs-serv10842

Modified Files:
      Tag: arensb-context
        deletemem.pl 
Log Message:
Use C4::Connect instead of C4::Database, C4::Connect->dbh instead
C4Connect.


Index: deletemem.pl
===================================================================
RCS file: /cvsroot/koha/koha/deletemem.pl,v
retrieving revision 1.3
retrieving revision 1.3.2.1
diff -C2 -r1.3 -r1.3.2.1
*** deletemem.pl        14 Aug 2002 18:12:51 -0000      1.3
--- deletemem.pl        4 Oct 2002 01:52:25 -0000       1.3.2.1
***************
*** 25,32 ****
  use strict;
  
- use C4::Search;
  use CGI;
  use C4::Output;
- use C4::Database;
  use C4::Circulation::Circ2;
  #use C4::Acquisitions;
--- 25,32 ----
  use strict;
  
  use CGI;
+ use C4::Context;
+ use C4::Search;
  use C4::Output;
  use C4::Circulation::Circ2;
  #use C4::Acquisitions;
***************
*** 45,49 ****
   }
    my ($bor,$flags)=getpatroninformation(\%env, $member,'');
! my $dbh=C4Connect;
  my $query="Select * from borrowers where guarantor='$member'";
  my $sth=$dbh->prepare($query);
--- 45,49 ----
   }
    my ($bor,$flags)=getpatroninformation(\%env, $member,'');
! my $dbh = C4::Context->dbh;
  my $query="Select * from borrowers where guarantor='$member'";
  my $sth=$dbh->prepare($query);
***************
*** 51,55 ****
  my $data=$sth->fetchrow_hashref;
  $sth->finish;
- $dbh->disconnect;
        
  
--- 51,54 ----
***************
*** 75,79 ****
  sub delmember{
    my ($member)address@hidden;
!   my $dbh=C4Connect;
    my $query="Select * from borrowers where borrowernumber='$member'";
    my $sth=$dbh->prepare($query);
--- 74,78 ----
  sub delmember{
    my ($member)address@hidden;
!   my $dbh = C4::Context->dbh;
    my $query="Select * from borrowers where borrowernumber='$member'";
    my $sth=$dbh->prepare($query);
***************
*** 87,101 ****
    $query=~ s/\,$/\)/;
    #  print $query;
    $sth=$dbh->prepare($query);
    $sth->execute;
    $sth->finish;
    $query = "Delete from borrowers where borrowernumber='$member'";
    $sth=$dbh->prepare($query);
    $sth->execute;
    $sth->finish;
    $query="Delete from reserves where borrowernumber='$member'";
    $sth=$dbh->prepare($query);
    $sth->execute;
    $sth->finish;
-   $dbh->disconnect;
  }
--- 86,102 ----
    $query=~ s/\,$/\)/;
    #  print $query;
+   # FIXME - Use $dbh->do()
    $sth=$dbh->prepare($query);
    $sth->execute;
    $sth->finish;
+   # FIXME - Use $dbh->do()
    $query = "Delete from borrowers where borrowernumber='$member'";
    $sth=$dbh->prepare($query);
    $sth->execute;
    $sth->finish;
+   # FIXME - Use $dbh->do()
    $query="Delete from reserves where borrowernumber='$member'";
    $sth=$dbh->prepare($query);
    $sth->execute;
    $sth->finish;
  }




reply via email to

[Prev in Thread] Current Thread [Next in Thread]