Attachment 59912 Details for Bug 18044 – Bug 18044: Label Batches not displaying

[patch] Bug 18044: Label Batches not displaying

Bug-18044-Label-Batches-not-displaying.patch (text/plain), 1.07 KB, created by Josef Moravec on 2017-02-06 06:39:45 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Josef Moravec

Created: 2017-02-06 06:39:45 UTC

Size: 1.07 KB

patch

obsolete

>From a6d7d4eec72def7b14dc0a1815bd5bf4ac744276 Mon Sep 17 00:00:00 2001
>From: Chris Nighswonger <cnighswonger@foundations.edu>
>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 <josef.moravec@gmail.com>
>---
> 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.1.4

Actions: View | Diff | Splinter Review

Attachments on bug 18044: 59909 | 59912 | 59913 | 59914