diff options
author | ivan <ivan> | 2007-12-05 20:50:20 +0000 |
---|---|---|
committer | ivan <ivan> | 2007-12-05 20:50:20 +0000 |
commit | 4ea9774ab600337021720675c1633fbf59826fed (patch) | |
tree | d3aae00738b334b61fe3e001c301a7c5315d691e /httemplate | |
parent | f97681d5e43b9cb75b1bd1a03bd47b09a694f9c2 (diff) |
doh, order_by does have to include ORDER BY!
Diffstat (limited to 'httemplate')
-rwxr-xr-x | httemplate/elements/tr-select-reason.html | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/httemplate/elements/tr-select-reason.html b/httemplate/elements/tr-select-reason.html index 04a5c4582..b57f78a1e 100755 --- a/httemplate/elements/tr-select-reason.html +++ b/httemplate/elements/tr-select-reason.html @@ -141,7 +141,7 @@ my @reasons = qsearch({ extra_sql => $extra_sql, addl_from => 'LEFT JOIN reason_type '. ' ON reason_type.typenum = reason.reason_type', - order_by => 'reason_type.type ASC, reason.reason ASC', + order_by => 'ORDER BY reason_type.type ASC, reason.reason ASC', }); my $curuser = $FS::CurrentUser::CurrentUser; |