From 0019e5e77b38f347c8c1210aa249bd7f666be824 Mon Sep 17 00:00:00 2001 From: Chris Nighswonger Date: Sun, 5 Feb 2017 16:11:30 -0500 Subject: [PATCH] Bug 18044: Label Batches not displaying SQL expects lists to be comma separated. A trailing comma must also be avoided. Signed-off-by: Josef Moravec Signed-off-by: Jonathan Druart --- C4/Creators/Lib.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/C4/Creators/Lib.pm b/C4/Creators/Lib.pm index c15b3e7..eb97bc1 100644 --- a/C4/Creators/Lib.pm +++ b/C4/Creators/Lib.pm @@ -151,7 +151,7 @@ sub _build_query { $query .= ' WHERE 1 '; while ( my ( $field, $values ) = each %{ $params->{filters} } ) { if ( ref( $values ) ) { - $query .= " AND $field IN ( " . ( ('?') x scalar( @$values ) ) . " ) "; + $query .= " AND $field IN ( " . ( ('?,') x (@$values-1) ) . "? ) "; # a comma separates elements in a list... push @where_args, @$values; } else { $query .= " AND $field = ? "; -- 2.9.3