X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=SL%2FIC.pm;h=fece79579b246e721289195d3a1c279450bae71f;hb=06af498f71c9424b2d373d12b4dd90cdac58e070;hp=2499decd025f7f9220d35c255f48a2eac9dee245;hpb=c3c267fe1364e57f5d52f5ee1f68242a7a61a3af;p=kivitendo-erp.git diff --git a/SL/IC.pm b/SL/IC.pm index 2499decd0..fece79579 100644 --- a/SL/IC.pm +++ b/SL/IC.pm @@ -188,10 +188,12 @@ sub get_part { # get translations $form->{language_values} = ""; - $query = qq|SELECT language_id, translation FROM translation WHERE parts_id = ?|; + $query = qq|SELECT language_id, translation, longdescription + FROM translation + WHERE parts_id = ?|; my $trq = prepare_execute_query($form, $dbh, $query, conv_i($form->{id})); - while ($tr = $trq->fetchrow_hashref(NAME_lc)) { - $form->{language_values} .= "---+++---".$tr->{language_id}."--++--".$tr->{translation}; + while (my $tr = $trq->fetchrow_hashref(NAME_lc)) { + $form->{language_values} .= "---+++---" . join('--++--', @{$tr}{qw(language_id translation longdescription)}); } $trq->finish;