[Koha-cvs] CVS: koha/admin stopwords.pl,1.10,1.10.2.1

[MJ Ray]

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

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

Index: stopwords.pl
===================================================================
RCS file: /cvsroot/koha/koha/admin/stopwords.pl,v
retrieving revision 1.10
retrieving revision 1.10.2.1
diff -C2 -r1.10 -r1.10.2.1
*** stopwords.pl	6 May 2003 14:55:39 -0000	1.10
--- stopwords.pl	5 Jan 2004 17:53:36 -0000	1.10.2.1
***************
*** 53,59 ****
  	my @data=split(' ',$searchstring);
  	my $count=@data;
! 	my $query="Select word from stopwords where (word like \"$data[0]%\") order by word";
! 	my $sth=$dbh->prepare($query);
! 	$sth->execute;
  	my @results;
  	my $cnt=0;
--- 53,59 ----
  	my @data=split(' ',$searchstring);
  	my $count=@data;
! 	my $query="";
! 	my $sth=$dbh->prepare("Select word from stopwords where (word like ?) order by word");
! 	$sth->execute("$data[0]%");
  	my @results;
  	my $cnt=0;
***************
*** 69,75 ****
  my $input = new CGI;
  my $searchfield=$input->param('searchfield');
- my $pkfield="word";
- my $reqsel="select word from stopwords where $pkfield='$searchfield'";
- my $reqdel="delete from stopwords where $pkfield='$searchfield'";
  my $offset=$input->param('offset');
  my $script_name="/cgi-bin/koha/admin/stopwords.pl";
--- 69,72 ----
***************
*** 100,105 ****
  	if ($searchfield) {
  		my $dbh = C4::Context->dbh;
! 		my $sth=$dbh->prepare("select word from stopwords where word='$searchfield'");
! 		$sth->execute;
  		$data=$sth->fetchrow_hashref;
  		$sth->finish;
--- 97,102 ----
  	if ($searchfield) {
  		my $dbh = C4::Context->dbh;
! 		my $sth=$dbh->prepare("select word from stopwords where word=?");
! 		$sth->execute($searchfield);
  		$data=$sth->fetchrow_hashref;
  		$sth->finish;
***************
*** 124,129 ****
  	$template->param(delete_confirm => 1);
  	my $dbh = C4::Context->dbh;
! 	my $sth=$dbh->prepare($reqsel);
! 	$sth->execute;
  	my $data=$sth->fetchrow_hashref;
  	$sth->finish;
--- 121,126 ----
  	$template->param(delete_confirm => 1);
  	my $dbh = C4::Context->dbh;
! 	my $sth=$dbh->prepare("select word from stopwords where word=?");
! 	$sth->execute($searchfield);
  	my $data=$sth->fetchrow_hashref;
  	$sth->finish;
***************
*** 134,139 ****
  	$template->param(delete_confirmed => 1);
  	my $dbh = C4::Context->dbh;
! 	my $sth=$dbh->prepare($reqdel);
! 	$sth->execute;
  	$sth->finish;
  													# END $OP eq DELETE_CONFIRMED
--- 131,136 ----
  	$template->param(delete_confirmed => 1);
  	my $dbh = C4::Context->dbh;
! 	my $sth=$dbh->prepare("delete from stopwords where word=?");
! 	$sth->execute($searchfield);
  	$sth->finish;
  													# END $OP eq DELETE_CONFIRMED