From 8e3181ae6373cbe58558ad2ad7ed5273a2b341d5 Mon Sep 17 00:00:00 2001 From: Jonathan Druart Date: Thu, 12 Feb 2015 11:08:00 +0100 Subject: [PATCH] Bug 13517: Reintroduce the field list It is preferable to list the fields we retrieve from the DB. Signed-off-by: Jonathan Druart --- C4/Reserves.pm | 22 ++++++++++++++++++++-- 1 file changed, 20 insertions(+), 2 deletions(-) diff --git a/C4/Reserves.pm b/C4/Reserves.pm index e62d74d..e05ef39 100644 --- a/C4/Reserves.pm +++ b/C4/Reserves.pm @@ -302,8 +302,26 @@ sub GetReservesFromBiblionumber { # Find the desired items in the reserves my @params; - my $query = " - SELECT * FROM reserves WHERE biblionumber = ? "; + my $query = q| + SELECT reserve_id, + branchcode, + timestamp, + priority, + biblionumber, + borrowernumber, + reservedate, + constrainttype, + found, + itemnumber, + reservenotes, + expirationdate, + lowestPriority, + suspend, + suspend_until, + waitingdate + FROM reserves + WHERE biblionumber = ? + |; push( @params, $biblionumber ); unless ( $all_dates ) { $query .= " AND reservedate <= CAST(NOW() AS DATE) "; -- 2.1.0