From: ivan <ivan>
Date: Tue, 23 Mar 2004 00:06:08 +0000 (+0000)
Subject: fix sorting of NULL companies differently than empty companies
X-Git-Tag: NET_WHOIS_RAW_0_31~42
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=cec266740d89b82ce9075954928c5b336d0ec18e;hp=a7319715290dccc7beb414de8d2de24230278a13

fix sorting of NULL companies differently than empty companies
---

diff --git a/httemplate/search/report_receivables.cgi b/httemplate/search/report_receivables.cgi
index ad353a1b3..0e95ad73c 100755
--- a/httemplate/search/report_receivables.cgi
+++ b/httemplate/search/report_receivables.cgi
@@ -93,7 +93,7 @@ where 0 <
            ,0
          )
 
-order by lower(company), lower(last)
+order by coalesce(lower(company), ''), lower(last)
 
 END