diff -r 45c139f74ea4 -r 4ce411ed28b6 fhiiqm/form/vertrag_form.inc.php --- a/fhiiqm/form/vertrag_form.inc.php Mon Jul 01 14:36:18 2013 +0200 +++ b/fhiiqm/form/vertrag_form.inc.php Wed Jul 31 15:10:48 2013 +0200 @@ -286,7 +286,7 @@ $select = null; if (is_array($vtr['cpers'])) $select = in_array( "-1", $vtr['cpers'] ) ? ' selected' : null; echo "\n"; - $sql = "SELECT persknr, CONCAT (nachname, ', ',vorname,' (',CASE aktiv WHEN 1 THEN 'aktiv' ELSE 'inaktiv' END, ')') as pname FROM fhiiqm.Mitarbeiter WHERE aktiv < 2 ORDER BY 2"; + $sql = "SELECT persknr, CONCAT (nachname, ', ',IFNULL(vorname,''),' (',CASE aktiv WHEN 1 THEN 'aktiv' ELSE 'inaktiv' END, ')') as pname FROM fhiiqm.Mitarbeiter WHERE aktiv < 2 ORDER BY 2"; if ($result = $dbc->queryObjectArray($sql)) { foreach ($result as $row)