--- 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";