--- DatabaseLayer.cpp 2006/09/01 03:08:06 24 +++ DatabaseLayer.cpp 2006/09/01 03:09:15 25 @@ -301,7 +301,7 @@ rs.Close(); // fill Equipment::reservations - SQL = "SELECT Resevation.StartDato, Resevation.Antaldage, Person.Initialer\ + SQL = "SELECT Resevation.ResevationID, Resevation.StartDato, Resevation.Antaldage, Person.Initialer\ FROM Resevation\ INNER JOIN Person ON Resevation.PersonID = Person.PersonID "; SQL += "WHERE Resevation.Stregkode = " + buffer[i].barcode + " ORDER BY STARTDATO ASC"; @@ -311,9 +311,10 @@ rs.MoveFirst(); while ( !rs.IsEOF() ) { Reservation res; - rs.GetFieldValue((short)0, res.startdate); - rs.GetFieldValue(1, res.numdays); - rs.GetFieldValue(2, res.inits); + rs.GetFieldValue((short)0, res.reservationID); + rs.GetFieldValue(1, res.startdate); + rs.GetFieldValue(2, res.numdays); + rs.GetFieldValue(3, res.inits); buffer[i].reservations.push_back(res); rs.MoveNext();