From 9e1590312f1b6f1ea5e67be9fac3cc471cd86415 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Sven=20Sch=C3=B6ling?= Date: Thu, 5 Nov 2009 15:07:38 +0100 Subject: [PATCH] get_bank_info: SQL Fehler bei mehr als einer id. MIME-Version: 1.0 Content-Type: text/plain; charset=utf8 Content-Transfer-Encoding: 8bit Fix für 1238. --- SL/CT.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/SL/CT.pm b/SL/CT.pm index 12df265d8..1b9d91593 100644 --- a/SL/CT.pm +++ b/SL/CT.pm @@ -1071,7 +1071,7 @@ sub get_bank_info { my $table = $params{vc} eq 'customer' ? 'customer' : 'vendor'; my @ids = ref $params{id} eq 'ARRAY' ? @{ $params{id} } : ($params{id}); - my $placeholders = ('?') x scalar @ids; + my $placeholders = join ", ", ('?') x scalar @ids; my $query = qq|SELECT id, name, account_number, bank, bank_code, iban, bic FROM ${table} WHERE id IN (${placeholders})|; -- 2.20.1