From: ivan Date: Thu, 17 Nov 2011 23:24:24 +0000 (+0000) Subject: optimize invoice rendering with lots of CDRs, RT#15155 X-Git-Tag: freeside_2_3_1~150 X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=07e3614f92d8fed7e43c3527d9ec262764494faa 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;