From 56ac016812b40c7a6e57d7db7b94b007d8f19c82 Mon Sep 17 00:00:00 2001 From: tipaul Date: Tue, 28 Jan 2003 14:57:33 +0000 Subject: [PATCH] fixing wrong sql query (use of ?) --- thesaurus_popup.pl | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/thesaurus_popup.pl b/thesaurus_popup.pl index 3038b67157..ba56402fa1 100755 --- a/thesaurus_popup.pl +++ b/thesaurus_popup.pl @@ -73,8 +73,8 @@ my %stdlib; my $select_list; if ($search_string) { # my $sti=$dbh->prepare("select id,freelib from bibliothesaurus where freelib like '".$search_string."%' and category ='$category'"); - my $sti=$dbh->prepare("select id,freelib from bibliothesaurus where match (category,freelib) AGAINST ('$search_string') and category ='$category'"); - $sti->execute; + my $sti=$dbh->prepare("select id,freelib from bibliothesaurus where match (category,freelib) AGAINST (?) and category ='$category'"); + $sti->execute($search_string); while (my $line=$sti->fetchrow_hashref) { $stdlib{$line->{'id'}} = "$line->{'freelib'}"; push(@freelib,$line->{'id'}); -- 2.20.1