--- trunk/tntnet/dynamic/critical.ecpp	2007/11/29 16:16:34	103
+++ trunk/tntnet/dynamic/critical.ecpp	2007/11/29 17:06:38	104
@@ -3,6 +3,20 @@
 #include <tntdb/connection.h>
 #include <tntdb/result.h>
 #include <tntdb/row.h>
+
+#include <vector>
+
+
+
+class CriticalInstallation
+{
+public:
+	CriticalInstallation() {}
+	CriticalInstallation(int i, std::string m) : id(i), message(m) {}
+	int id;
+	std::string message;
+};
+
 </%pre>
 
 <%config>
@@ -11,10 +25,20 @@
 
 <&header title="Critical systems">
 </&header>
+<h2>Critical systems</h2>
+
 <{
-tntdb::Connection conn;
 
-conn = tntdb::connect(dburl); //letting exceptions flow up and to tntnet and let it display an error message
+
+std::vector<CriticalInstallation> criticals;
+
+tntdb::Connection conn = tntdb::connect(dburl); 
+
+tntdb::Result res = conn.select("SELECT id FROM installation WHERE commerror = true");
+for (int i=0; i<res.size(); ++i)
+{
+	criticals.push_back(CriticalInstallation(res[i].getInt(0), std::string("Communication Error")));
+}
 
 }>