From cd2f4d3fcce14c3cf5dae36631cc8d0f46b6f781 Mon Sep 17 00:00:00 2001 From: Adrien Saurat Date: Tue, 8 Jan 2013 14:08:25 +0100 Subject: [PATCH] Bug 9362: SQL fix in GetUpcomingDueIssues --- C4/Circulation.pm | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/C4/Circulation.pm b/C4/Circulation.pm index 71fe20f..13c6aae 100644 --- a/C4/Circulation.pm +++ b/C4/Circulation.pm @@ -2384,7 +2384,7 @@ FROM issues LEFT JOIN items USING (itemnumber) LEFT OUTER JOIN branches USING (branchcode) WhERE returndate is NULL -AND ( TO_DAYS( NOW() )-TO_DAYS( date_due ) ) < ? +AND ( TO_DAYS( date_due )-TO_DAYS( NOW() ) ) < ? END_SQL my @bind_parameters = ( $params->{'days_in_advance'} ); -- 1.7.5.4