diff options
| author | ivan <ivan> | 2004-03-23 00:06:09 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2004-03-23 00:06:09 +0000 |
| commit | ef158b1f6fc60f8e114bb01b82c3de0754fedef2 (patch) | |
| tree | 46217cce77441fa1b608ef387a0730cee73a93a2 /httemplate | |
| parent | 4c02509437727cf0685c6ecf35949bef7d5f6bc1 (diff) | |
fix sorting of NULL companies differently than empty companies
Diffstat (limited to 'httemplate')
| -rwxr-xr-x | httemplate/search/report_receivables.cgi | 2 |
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 |