[Koha-cvs] CVS: koha/C4 Catalogue.pm,1.36.2.1,1.36.2.2
Paul POULAIN
tipaul at users.sourceforge.net
Thu Feb 19 11:16:35 CET 2004
Update of /cvsroot/koha/koha/C4
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv22883/C4
Modified Files:
Tag: rel_2_0
Catalogue.pm
Log Message:
#662 prepare/execute with (?)
Index: Catalogue.pm
===================================================================
RCS file: /cvsroot/koha/koha/C4/Catalogue.pm,v
retrieving revision 1.36.2.1
retrieving revision 1.36.2.2
diff -C2 -r1.36.2.1 -r1.36.2.2
*** Catalogue.pm 13 Jan 2004 17:30:23 -0000 1.36.2.1
--- Catalogue.pm 19 Feb 2004 10:16:31 -0000 1.36.2.2
***************
*** 828,835 ****
my ($searchstring)=@_;
my $dbh = C4::Context->dbh;
! my $query="Select * from aqbooksellers where name like '$searchstring%' or
! id = '$searchstring'";
my $sth=$dbh->prepare($query);
! $sth->execute;
my @results;
my $i=0;
--- 828,834 ----
my ($searchstring)=@_;
my $dbh = C4::Context->dbh;
! my $query="Select * from aqbooksellers where name like ? or id =? ";
my $sth=$dbh->prepare($query);
! $sth->execute("$searchstring%",$searchstring);
my @results;
my $i=0;
More information about the Koha-cvs
mailing list