--- trunk/tntnet/dynamic/customerlist.ecpp	2007/11/27 22:25:36	74
+++ trunk/tntnet/dynamic/customerlist.ecpp	2007/12/08 16:47:03	195
@@ -13,7 +13,7 @@
 dburl;
 </%config>
 
-<&header title="Critical systems">
+<&header title="Customers and installations">
 </&header>
 
 <h2>Customers and installations</h2>
@@ -21,7 +21,7 @@
 <{
 tntdb::Connection conn;
 
-conn = tntdb::connect(dburl); //letting exceptions flow up and to tntnet and let it display an error message
+conn = tntdb::connectCached(dburl); //letting exceptions flow up and to tntnet and let it display an error message
 
 std::string customer_sql = "SELECT id,name,address,phonenr,contactperson FROM customer ORDER BY name ASC";
 
@@ -50,13 +50,14 @@
 		std::stringstream sqlstream;
 		sqlstream << "SELECT id, description FROM installation ";
 		sqlstream << "WHERE customerid = " << customerid;
+		sqlstream << " ORDER BY description ASC";
 
 		tntdb::Result instres = conn.select(sqlstream.str());
 
 		if (instres.size() > 0)
 		{
 			out << "Installations:\n";
-			out << "<ol style='margin-top:0px;'>\n";
+			out << "<ol>\n";
 			for (tntdb::Result::const_iterator instit = instres.begin(); instit != instres.end(); ++instit)
 			{
 				tntdb::Row instrow = *instit;