--- MySQLLayer.cpp	2006/09/12 09:09:30	54
+++ MySQLLayer.cpp	2006/09/12 10:16:06	56
@@ -214,7 +214,7 @@
 Equipment MySQLLayer::GetEquipment(CString wantBarcode)
 {
 
-	CString barcode,name,description,placement,status;
+	CString barcode,name,description,placement,status,statusid;
 
 	CString SQL;
 
@@ -222,7 +222,7 @@
 
 	Equipment e;
 
-	SQL.Format((CString)"SELECT Stregkode,Navn,Udstyr.Beskrivelse,Placering,Status.Beskrivelse FROM Udstyr " + 
+	SQL.Format((CString)"SELECT Stregkode,Navn,Udstyr.Beskrivelse,Placering,Status.Beskrivelse,Udstyr.Status FROM Udstyr " + 
 		"INNER JOIN Status ON Udstyr.Status = Status.StatusID Where (Stregkode = '%s')", wantBarcode);
 	CRecordset rs(&db);
 	rs.Open(AFX_DB_USE_DEFAULT_TYPE, SQL);
@@ -233,12 +233,14 @@
 		rs.GetFieldValue(2,description);
 		rs.GetFieldValue(3,placement);
 		rs.GetFieldValue(4,status);
+		rs.GetFieldValue(5,statusid);
 
 		e.barcode = barcode;
 		e.name = name;
 		e.description = description;
 		e.placement = placement;
 		e.status = status;
+		e.statusid = atoi( statusid );
 
 		rs.Close();