summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorivan <ivan>2004-03-23 00:06:09 +0000
committerivan <ivan>2004-03-23 00:06:09 +0000
commitef158b1f6fc60f8e114bb01b82c3de0754fedef2 (patch)
tree46217cce77441fa1b608ef387a0730cee73a93a2
parent4c02509437727cf0685c6ecf35949bef7d5f6bc1 (diff)
fix sorting of NULL companies differently than empty companies
-rwxr-xr-xhttemplate/search/report_receivables.cgi2
1 files changed, 1 insertions, 1 deletions
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