From: Joey Schulze <joey@infodrom.org>
Date: Thu, 11 Mar 2010 11:18:11 +0000 (+0100)
Subject: Add another ORDER BY part
X-Git-Tag: 2010-06-02_customer~53
X-Git-Url: https://git.infodrom.org/?p=misc%2Fkostenrechnung;a=commitdiff_plain;h=bbbbd7533ad2c0f04873186d28042faf098ac9fa;hp=a0d1cb54435fbef1ad06f52dd24920a146deeb1c

Add another ORDER BY part
---

diff --git a/masks/arbeitsberichte.php b/masks/arbeitsberichte.php
index c301d2a..3d94103 100644
--- a/masks/arbeitsberichte.php
+++ b/masks/arbeitsberichte.php
@@ -355,9 +355,9 @@ $mask = array(
 					    'sql' => 'SELECT id,kostenstelle AS text FROM kostenstellen WHERE gebiet = {gebiet} ORDER BY text',
 					    ),
 			      'anbaugeraete' => array(
-					    'sql' => 'SELECT anbaugeraete.id,anbaugeraet as TEXT FROM anbaugeraete ' .
+					    'sql' => 'SELECT anbaugeraete.id,anbaugeraet as text FROM anbaugeraete ' .
 						     'JOIN gerate ON anbaugeraete.geraetetyp = gerate.geraetetyp ' .
-						     'WHERE gerate.id = {geraet}',
+						     'WHERE gerate.id = {geraet} ORDER BY text',
 					    ),
 				   ),
 	      );