From feaaffd0b1b891553311827393c283b8c0eb81a4 Mon Sep 17 00:00:00 2001 From: Paul Poulain Date: Mon, 16 Nov 2009 16:02:52 +0100 Subject: [PATCH] missing ) result in SQL error --- C4/Budgets.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/C4/Budgets.pm b/C4/Budgets.pm index debb6fa20c..3c3c4c3e40 100644 --- a/C4/Budgets.pm +++ b/C4/Budgets.pm @@ -477,7 +477,7 @@ sub GetBudgetHierarchy { # show only budgets owned by me, my branch or everyone if ($owner) { if ($branchcode) { - push @where_strings,qq{ (budget_owner_id = ? OR budget_branchcode = ? OR (budget_branchcode IS NULL or budget_branchcode="" AND (budget_owner_id IS NULL OR budget_owner_id=""))}; + push @where_strings,qq{ (budget_owner_id = ? OR budget_branchcode = ? OR (budget_branchcode IS NULL or budget_branchcode="" AND (budget_owner_id IS NULL OR budget_owner_id="")))}; push @bind_params, ($owner, $branchcode); } else { push @where_strings, ' (budget_owner_id = ? OR budget_owner_id IS NULL or budget_owner_id ="") '; -- 2.20.1