--- 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](temperaturegraph?id=<$id$>)
+
<{
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";