From: ivan Date: Thu, 17 Nov 2011 23:24:21 +0000 (+0000) Subject: optimize invoice rendering with lots of CDRs, RT#15155 X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=f1371047a59f62165fa3b6d639af72e03cba9a8f optimize invoice rendering with lots of CDRs, RT#15155 --- diff --git a/FS/FS/cust_bill_pkg.pm b/FS/FS/cust_bill_pkg.pm index 2c157150d..58e24192f 100644 --- a/FS/FS/cust_bill_pkg.pm +++ b/FS/FS/cust_bill_pkg.pm @@ -470,7 +470,7 @@ sub details { my $sql = "SELECT detail FROM cust_bill_pkg_detail ". " WHERE billpkgnum = ". $self->billpkgnum. - " AND ( format IS NULL OR format != 'C' ". + " AND ( format IS NULL OR format != 'C' ) ". " ORDER BY detailnum"; my $sth = dbh->prepare($sql) or die dbh->errstr; $sth->execute or die $sth->errstr;