diff options
| author | ivan <ivan> | 2004-03-23 00:06:08 +0000 |
|---|---|---|
| committer | ivan <ivan> | 2004-03-23 00:06:08 +0000 |
| commit | cec266740d89b82ce9075954928c5b336d0ec18e (patch) | |
| tree | e133ded65963e4da6534a87db2a5a0fc1fba2cb0 /httemplate | |
| parent | a7319715290dccc7beb414de8d2de24230278a13 (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 |