fhiiqm/form/info_allg_search_form.inc.php
changeset 31 0a1eb975fbd9
parent 29 72f79dab938e
--- a/fhiiqm/form/info_allg_search_form.inc.php	Fri Aug 31 14:22:20 2012 +0200
+++ b/fhiiqm/form/info_allg_search_form.inc.php	Fri Nov 16 10:39:25 2012 +0100
@@ -44,7 +44,7 @@
             echo "<td><select name='inf[ityp]'>";
                 if ($inf["ityp"] == -1) $select = " selected "; else $select = "";
                 echo "<option $select value=\"-1\"></option>\n";
-                $sql = "SELECT infotyp_ID, infotyp_bez FROM Info_Typ ORDER BY 1";
+                $sql = "SELECT infotyp_ID, infotyp_bez FROM Info_Typ ORDER BY CONVERT(infotyp_ID,CHAR)";
                 if ($result = $dbc->queryObjectArray($sql))
                 {
                     $select = "";