--- 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 = "";