--- trunk/tntnet/dynamic/installationdetails.ecpp 2007/12/02 20:26:43 126 +++ trunk/tntnet/dynamic/installationdetails.ecpp 2007/12/09 19:46:49 202 @@ -32,7 +32,7 @@ <{ tntdb::Connection conn; -conn = tntdb::connect(dburl); +conn = tntdb::connectCached(dburl); std::stringstream query; query << "SELECT c.name, c.address AS caddress, i.description, i.address AS iadress, i.furnacetype, i.updaterate, i.commerror "; @@ -74,7 +74,7 @@ Comm. status: - " alt="Status Indicator"> + " alt="Status Indicator"> @@ -88,7 +88,7 @@ query << "SELECT messagenr, date_trunc('second', logtime) AS logtime, temperature, flamedetector, solidfuelempty, conveyorerror,powerfailure "; query << "FROM logtable "; query << "WHERE installationnr = " << id; - query << "ORDER BY messagenr DESC"; + query << "ORDER BY messagenr DESC, logtime DESC "; res = conn.select(query.str()); @@ -110,7 +110,7 @@ out << ""; out << "" << messagenr << "\n"; - out << "" << logtime << "\n"; + out << " " << logtime << " \n"; out << "90 ? critical : "" ) << ">" << temperature << "\n"; out << "" << convert_bool(flamedetector) << "\n"; out << "" << convert_bool(solidfuelempty) << "\n";