From 674ff6027a185fa608933fd4d42cb92c5e5bfb7a Mon Sep 17 00:00:00 2001 From: miker Date: Tue, 25 Nov 2008 15:59:43 +0000 Subject: [PATCH] syntax error when moving to the per-penalty loop git-svn-id: svn://svn.open-ils.org/ILS/trunk@11343 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/110.hold_matrix.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/sql/Pg/110.hold_matrix.sql b/Open-ILS/src/sql/Pg/110.hold_matrix.sql index 0aebe89796..1639ab3b86 100644 --- a/Open-ILS/src/sql/Pg/110.hold_matrix.sql +++ b/Open-ILS/src/sql/Pg/110.hold_matrix.sql @@ -255,7 +255,7 @@ BEGIN JOIN config.standing_penalty csp ON (csp.id = usp.standing_penalty) WHERE usr = match_user AND usp.org_unit IN ( SELECT * FROM explode_array(context_org_list) ) - AND csp.block_list LIKE '%HOLD%'; + AND csp.block_list LIKE '%HOLD%' LOOP result.fail_part := standing_penalty.name; result.success := FALSE; @@ -270,7 +270,7 @@ BEGIN JOIN config.standing_penalty csp ON (csp.id = usp.standing_penalty) WHERE usr = match_user AND usp.org_unit IN ( SELECT * FROM explode_array(context_org_list) ) - AND csp.block_list LIKE '%CIRC%'; + AND csp.block_list LIKE '%CIRC%' LOOP result.fail_part := standing_penalty.name; result.success := FALSE; -- 2.11.0