--- trunk/tntnet/dynamic/installationdetails.ecpp	2007/12/02 16:56:14	122
+++ trunk/tntnet/dynamic/installationdetails.ecpp	2007/12/08 16:47:03	195
@@ -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 @@
 	</tr>
 	<tr>
 		<td>Comm. status: </td>
-		<td><img src="bullet.php?rgb=<$ (res[0].getBool(6) ? "ff0000" : "00ff00") $>" alt="Status Indicator"></td>
+		<td><img src="bullet?rgb=<$ (res[0].getBool(6) ? "ff0000" : "00ff00") $>" alt="Status Indicator"></td>
 	</tr>
 
 
@@ -88,14 +88,14 @@
 	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());	
 
 
 	out << "<table border=1 cellspacing=0 align='center'>\n";
 	out << "<tr><th>&nbsp;Message#&nbsp;</th><th>&nbsp;Logtime&nbsp;</th><th>&nbsp;Temperature&nbsp;</th><th>&nbsp;Flamedetector&nbsp;</th><th>&nbsp;Solidfuel empty&nbsp;</th><th>&nbsp;Conveyor error&nbsp;</th><th>&nbsp;Power failure&nbsp;</th></tr>\n";
 
-	for (int i=0; i<res.size(); ++i)
+	for (unsigned int i=0; i<res.size(); ++i)
 	{
 		int messagenr = res[i].getInt(0);
 		std::string logtime = res[i].getString(1);