--- trunk/tntnet/dynamic/customerlist.ecpp 2007/11/27 22:25:36 74
+++ trunk/tntnet/dynamic/customerlist.ecpp 2007/12/02 16:56:14 122
@@ -13,7 +13,7 @@
dburl;
%config>
-<&header title="Critical systems">
+<&header title="Customers and installations">
&header>
Customers and installations
@@ -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 << "\n";
+ out << "\n";
for (tntdb::Result::const_iterator instit = instres.begin(); instit != instres.end(); ++instit)
{
tntdb::Row instrow = *instit;