--- a/fhiiqm/raum_upd.php	Thu Apr 18 14:32:42 2013 +0200
+++ b/fhiiqm/raum_upd.php	Mon Jul 01 14:36:18 2013 +0200
@@ -79,7 +79,7 @@
         if (!$upd && !$del)
         {
             $sql = "SELECT raum_ID,raum_nr,raum_name,geb_ID,raumtyp_ID,reinigung_typ_ID,raum_flaeche,raum_file,
-                    reinigung_kat,reinigung_turnus_ID,boden_typ_ID 
+                    reinigung_kat,reinigung_turnus_ID,boden_typ_ID,raum_bem 
                     FROM fhiiqm.Raum WHERE raum_ID = $rid";
             if ($result = $dbc ->queryObjectArray($sql))
             {
@@ -87,14 +87,15 @@
                 {
                     $raum['rnum']       = $row->raum_nr;
                     $raum['rbez']       = $row->raum_name;
-                    $raum['geb']       = $row->geb_ID;
+                    $raum['geb']        = $row->geb_ID;
                     $raum['rtyp']       = $row->raumtyp_ID;
-                    $raum['reityp']       = $row->reinigung_typ_ID;
+                    $raum['reityp']     = $row->reinigung_typ_ID;
                     $raum['rflae']      = str_replace(".",",",$row->raum_flaeche);
                     $raum['rfname']     = $row->raum_file;
                     $raum['reikat']     = $row->reinigung_kat;
                     $raum['reitur']     = $row->reinigung_turnus_ID;
-                    $raum['boden']     = $row->boden_typ_ID;
+                    $raum['boden']      = $row->boden_typ_ID;
+//                    $raum['bem']        = $row->raum_bem;
                 }  
             }
         }
@@ -150,6 +151,8 @@
         //UPDATE Raum
         $raum['rbez'] = substr($raum['rbez'],0,50);
         $raum['rnum'] = substr($raum['rnum'],0,10);
+//        $raum['bem']  = substr($raum['bem'],0,800);
+//        if (!isset($raum['bem']) || $raum['bem']<'!') $raum['bem'] = null;
         if ($raum['rtyp']== -1) $raum['rtyp'] = null;
         if ($raum['reityp']== -1) $raum['reityp'] = null;
         if ($raum['reikat']== -1) $raum['reikat'] = null;