View | Details | Raw Unified | Return to bug 14206
Collapse All | Expand All

(-)a/C4/Letters.pm (-2 / +2 lines)
Lines 226-232 sub getletter { Link Here
226
    my $sth = $dbh->prepare(q{
226
    my $sth = $dbh->prepare(q{
227
        SELECT *
227
        SELECT *
228
        FROM letter
228
        FROM letter
229
        WHERE module=? AND code=? AND (branchcode = ? OR branchcode = '') AND message_transport_type = ?
229
        WHERE module=? AND code=? AND (branchcode = ? OR branchcode = '')
230
        AND (message_transport_type = ? OR message_transport_type IN (SELECT message_transport_type FROM message_transport_types))
230
        ORDER BY branchcode DESC LIMIT 1
231
        ORDER BY branchcode DESC LIMIT 1
231
    });
232
    });
232
    $sth->execute( $module, $code, $branchcode, $message_transport_type );
233
    $sth->execute( $module, $code, $branchcode, $message_transport_type );
233
- 

Return to bug 14206