From: Mark Wells <mark@freeside.biz>
Date: Wed, 9 Apr 2014 19:53:24 +0000 (-0700)
Subject: correctly alias itemdesc column, #28506
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=84abddf4bf0bc90e4a8f6e8e546e3cf4ee2786a2

correctly alias itemdesc column, #28506
---

diff --git a/httemplate/search/cust_bill_pkg.cgi b/httemplate/search/cust_bill_pkg.cgi
index fe16f3aa5..b1086e3dc 100644
--- a/httemplate/search/cust_bill_pkg.cgi
+++ b/httemplate/search/cust_bill_pkg.cgi
@@ -326,7 +326,7 @@ push @select, "COALESCE($part_pkg.taxclass, part_fee.taxclass) AS taxclass"
 # the non-tax case
 if ( $cgi->param('nottax') ) {
 
-  push @select, $itemdesc;
+  push @select, "($itemdesc) AS itemdesc";
 
   push @where,
     '(cust_bill_pkg.pkgnum > 0 OR cust_bill_pkg.feepart IS NOT NULL)';