--- trunk/tntnet/dynamic/installationdetails.ecpp 2007/12/03 07:34:21 127 +++ trunk/tntnet/dynamic/installationdetails.ecpp 2007/12/09 21:08:55 206 @@ -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 "; @@ -80,15 +80,16 @@ - +

Temperature graph

+
<{ query.str(""); //reset stringstream 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 +111,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";