From 0f568852a8ec69c71a96f9d7c37e024fb9b76c95 Mon Sep 17 00:00:00 2001 From: bob_lyon Date: Tue, 6 Jun 2006 23:13:14 +0000 Subject: [PATCH] Merging katipo changes... altering subject search to stop returning blank rows --- C4/Biblio.pm | 9 ++++++++- 1 file changed, 8 insertions(+), 1 deletion(-) diff --git a/C4/Biblio.pm b/C4/Biblio.pm index 5c78d0cd80..f70b137178 100644 --- a/C4/Biblio.pm +++ b/C4/Biblio.pm @@ -2263,7 +2263,9 @@ sub bibdata { } # while $data->{subtitles} = \@subtitles; $sth->finish; - $sth = $dbh->prepare("Select * from bibliosubject where biblionumber = ?"); + $sth = $dbh->prepare("SELECT * FROM bibliosubject + WHERE subject != '' + AND biblionumber = ?"); $sth->execute($bibnum); my @subjects; while (my $dat = $sth->fetchrow_hashref){ @@ -3127,6 +3129,11 @@ Paul POULAIN paul.poulain@free.fr # $Id$ # $Log$ +# Revision 1.172 2006/06/06 23:13:14 bob_lyon +# Merging katipo changes... +# +# altering subject search to stop returning blank rows +# # Revision 1.171 2006/05/17 16:06:24 plg # New feature from SAN Ouest Provence: ability to reserve a specific item in # the intranet. The development was made on branch 2.2 by Arnaud Laurin from -- 2.20.1